WITH INDEX_TABLE AS( SELECT 2 as DatabaseID, o.name AS TableName, c.name AS ColumnName,ic.index_id,i.type_desc AS IndexType FROM SYS.OBJECTS O JOIN SYS.index_columns IC ON IC.OBJECT_ID = O.OBJECT_ID JOIN SYS.COLUMNS C ON IC.column_id = C.column_id and C.OBJECT_ID = O.OBJECT_ID JOIN SYS.INDEXES I ON I.OBJECT_ID = O.OBJECT_ID AND I.index_id = IC.index_id WHERE o.type_desc = 'user_table' AND O.name NOT LIKE '_Staging%' ) SELECT * FROM INDEX_TABLE