table sysindexes contains a row for each index and a row for each table without a clustered index. : sysindexes « System Tables Views « SQL Server / T-SQL Tutorial
- SQL Server / T-SQL Tutorial
- System Tables Views
- sysindexes
3>
4> select top 10 * from sysindexes;
5> GO
id status first
indid root
minlen keycnt groupid dpages reserved used rowcnt rowmodctr reserved3 reserved4 xmaxlen maxirow OrigFillFact
or StatVersion reserved2 FirstIAM
impid lockflags pgmodctr keys
name
statblob
maxlen rows
----------- ----------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------------------------ ------ ------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------ ------ ------ ------- ----------- ----------- ----------- -------------------- ----------- --------- --------- ------- ------- ------------
-- ----------- ----------- -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------- ------ --------- ----------- -----------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------
-------------- -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------- ----------- -----------
4 18 0x0F0000000100
1 0x6C0000000100
34 2 1 7 9 9 697 1179600 0 0 37 19
0 0 0 0x930000000100
0 0 0 NULL
clust
NULL
8000 697
5 18 0x100000000100
1 0x100000000100
39 1 1 1 2 2 102 742 0 0 42 15
0 0 0 0xA70000000100
0 0 0 NULL
clust
NULL
8000 102
7 18 0x130000000100
1 0x780100000100
69 1 1 2 4 4 113 744 0 0 73 15
0 0 0 0x140000000100
0 0 0 NULL
clust
NULL
8000 113
8 0 0x200000000100
0 0x200000000100
786 0 1 1 2 2 2 4 0 0 789 0
0 0 0 0x0D0000000100
0 0 0 NULL
NULL
NULL
8000 2
13 18 0x110000000100
1 0x150000000100
41 2 1 7 15 9 697 4341 0 0 45 19
0 0 0 0x940000000100
0 0 0 NULL
clust
NULL
8000 697
15 18 0x120000000100
1 0x120000000100
37 1 1 1 2 2 102 742 0 0 41 15
0 0 0 0x6F0000000100
0 0 0 NULL
clust
NULL
8000 102
25 18 0x000000000000
1 0x000000000000
61 1 1 0 0 0 0 0 0 0 65 15
0 0 0 0x000000000000
0 0 0 NULL
clst
NULL
8000 0
26 18 0x8A0300000100
1 0x960000000100
21 3 1 1 2 2 113 744 0 0 24 24
0 0 0 0x950000000100
0 0 0 NULL
clust
NULL
8000 113
27 18 0xB00200000100
1 0x460100000100
29 1 1 1 6 6 15 1 0 0 908 15
0 0 0 0x450100000100
0 0 0 NULL
clst
NULL
8000 15
27 2 0xB20200000100
2 0x440100000100
5 2 1 1 2 2 15 1 0 0 281 267
0 0 0 0x430100000100
0 0 0 NULL
nc1
NULL
8000 15
(10 rows affected)
1>