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