인덱스 조회

SELECT
    name AS index_name,
    index_id,
    type_desc
FROM
    sys.indexes
WHERE
    object_id = OBJECT_ID(N'[dbo].[테이블명]')