mikaelsnavy
11/18/2015 - 4:57 PM

Drop Index if it already exists

Drop Index if it already exists

IF EXISTS(SELECT * FROM sys.indexes WHERE object_id = object_id('schema.tablename') AND NAME ='indexname')
    DROP INDEX indexname ON SCHEMA.tablename;