SELECT OBJECT_NAME(OBJECT_ID), Name, type_desc, is_disabled
FROM sys.indexes
WHERE OBJECT_NAME(OBJECT_ID) = 'Pubdoorauth'
結果
Name type_desc is_disabled
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------ -----------
PubDoorAuth NULL HEAP 0
PubDoorAuth PK_PUBDOORAUTH NONCLUSTERED 0
PubDoorAuth IX_PubDoorAuth_Door NONCLUSTERED 0
PubDoorAuth IX_PubDoorAuth_Unque NONCLUSTERED 0
PubDoorAuth IX_PubDoorAuth_Week NONCLUSTERED 0
(5 個資料列受到影響)
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
SELECT i.name AS index_name
,COL_NAME(ic.object_id,ic.column_id) AS column_name
,ic.index_column_id
,ic.key_ordinal
,ic.is_included_column
FROM sys.indexes AS i
INNER JOIN sys.index_columns AS ic
ON i.object_id = ic.object_id AND i.index_id = ic.index_id
WHERE i.object_id = OBJECT_ID('Pubdoorauth');
結果
index_name column_name index_column_id key_ordinal is_included_column
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- --------------- ----------- ------------------
PK_PUBDOORAUTH rowAutoID 1 1 0
IX_PubDoorAuth_Door doorID 1 1 0
IX_PubDoorAuth_Unque personID 1 1 0
IX_PubDoorAuth_Unque doorID 2 2 0
IX_PubDoorAuth_Unque weekTimeID 3 3 0
IX_PubDoorAuth_Unque holidayGroupID 4 4 0
IX_PubDoorAuth_Week weekTimeID 1 1 0
(7 個資料列受到影響)