USE AdventureWorks
SELECT id '物件編號',
       indid '索引編號',
       name '索引名稱'
FROM sys.sysindexes
WHERE OBJECT_NAME(id)='Department'

SELECT *
FROM sys.sysindexes
WHERE OBJECT_NAME(id)='TSCUUser'

id, status, first, indid, root, minlen, keycnt, groupid, dpages, reserved, used, rowcnt, rowmodctr, reserved3, reserved4, xmaxlen, maxirow, OrigFillFactor, StatVersion, reserved2, FirstIAm, impid, lockflags, pgmodctr, keys, name, statblob, maxlen, rows
757577737	2066	0x5D0000000100	1	0x5D0000000100	426	1	1	1	2	2	4	0	0	0	430	47	0	0	0	0x730000000100	0	0	0	NULL		PK_TScuUser	NULL	8000	4
757577737	8388704	NULL		2	NULL		0	1	0	0	0	0	0	0	0	0	0	NULL	0	0	0	NULL	0	0	0	NULL	_WA_Sys_00000002_2D27B809	NULL	8000	0
757577737	8388704	NULL		3	NULL		0	1	0	0	0	0	0	0	0	0	0	NULL	0	0	0	NULL	0	0	0	NULL	_WA_Sys_00000003_2D27B809	NULL	8000	0
757577737	8388704	NULL		4	NULL		0	1	0	0	0	0	0	0	0	0	0	NULL	0	0	0	NULL	0	0	0	NULL	_WA_Sys_00000004_2D27B809	NULL	8000	0
757577737	8388704	NULL		5	NULL		0	1	0	0	0	0	0	0	0	0	0	NULL	0	0	0	NULL	0	0	0	NULL	_WA_Sys_00000005_2D27B809	NULL	8000	0
757577737	8388704	NULL		6	NULL		0	1	0	0	0	0	0	5	0	0	0	NULL	0	0	0	NULL	0	0	0	NULL	_WA_Sys_00000006_2D27B809	NULL	8000	0
757577737	8388704	NULL		7	NULL		0	1	0	0	0	0	0	0	0	0	0	NULL	0	0	0	NULL	0	0	0	NULL	_WA_Sys_00000007_2D27B809	NULL	8000	0
757577737	8388704	NULL		8	NULL		0	1	0	0	0	0	0	0	0	0	0	NULL	0	0	0	NULL	0	0	0	NULL	_WA_Sys_00000008_2D27B809	NULL	8000	0
757577737	8388704	NULL		9	NULL		0	1	0	0	0	0	0	0	0	0	0	NULL	0	0	0	NULL	0	0	0	NULL	_WA_Sys_00000009_2D27B809	NULL	8000	0
757577737	8388704	NULL		10	NULL		0	1	0	0	0	0	0	0	0	0	0	NULL	0	0	0	NULL	0	0	0	NULL	_WA_Sys_0000000A_2D27B809	NULL	8000	0
757577737	8388704	NULL		11	NULL		0	1	0	0	0	0	0	0	0	0	0	NULL	0	0	0	NULL	0	0	0	NULL	_WA_Sys_0000000B_2D27B809	NULL	8000	0
757577737	8388704	NULL		12	NULL		0	1	0	0	0	0	0	0	0	0	0	NULL	0	0	0	NULL	0	0	0	NULL	_WA_Sys_0000000C_2D27B809	NULL	8000	0
757577737	8388704	NULL		13	NULL		0	1	0	0	0	0	0	0	0	0	0	NULL	0	0	0	NULL	0	0	0	NULL	_WA_Sys_0000000D_2D27B809	NULL	8000	0
757577737	8388704	NULL		14	NULL		0	1	0	0	0	0	0	0	0	0	0	NULL	0	0	0	NULL	0	0	0	NULL	_WA_Sys_0000000E_2D27B809	NULL	8000	0
757577737	8388704	NULL		15	NULL		0	1	0	0	0	0	0	0	0	0	0	NULL	0	0	0	NULL	0	0	0	NULL	_WA_Sys_0000000F_2D27B809	NULL	8000	0