mikaelsnavy
11/18/2015 - 4:57 PM

Drop Index if it already exists

Drop Index if it already exists

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