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;