Cacher is the code snippet organizer for pro developers

IF EXISTS (SELECT name from sys.indexes  
           WHERE name = N'index_name')   
   DROP INDEX index_name ON schema.tableName;   
GO  

CREATE UNIQUE INDEX index_name   
   ON schema.tableName (colName);   
GO