pchriste24
8/30/2018 - 3:21 PM

Query Indexes

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