인덱스에 포함된 열 조회

특정 테이블의 인덱스들 중 포함된 (Included Column)열을 확인하기 위해서 사용합니다.

SELECT DISTINCT T.Name 'Table Name',
        I.Name 'Index Name',
        I.type_desc 'Index Type',
        C.Name 'Included Column Name'
FROM sys.indexes I 
 INNER JOIN sys.index_columns IC 
  ON  I.object_id = IC.object_id AND I.index_id = IC.index_id 
 INNER JOIN sys.columns C 
  ON IC.object_id = C.object_id and IC.column_id = C.column_id 
 INNER JOIN sys.tables T 
  ON I.object_id = T.object_id 
WHERE is_included_column = 1 and T.name='MARC'
ORDER BY T.Name, I.Name