Query a schema for an index by name and table
IF EXISTS (SELECT * FROM sys.indexes WHERE name='Index_Name' AND object_id = OBJECT_ID('[SchmaName].[TableName]')) begin end