sysindexes


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int 4 null
status int 4 √ null
first binary 6 √ null
indid smallint 2 √ null
root binary 6 √ null
minlen smallint 2 √ null
keycnt smallint 2 √ null
groupid smallint 2 √ null
dpages int 4 √ null
reserved int 4 √ null
used int 4 √ null
rowcnt bigint 8 √ null
rowmodctr int 4 √ null
reserved3 tinyint 1 √ null
reserved4 tinyint 1 √ null
xmaxlen smallint 2 √ null
maxirow smallint 2 √ null
OrigFillFactor tinyint 1 √ null
StatVersion tinyint 1 √ null
reserved2 int 4 √ null
FirstIAM binary 6 √ null
impid smallint 2 √ null
lockflags smallint 2 √ null
pgmodctr int 4 √ null
keys varbinary 1088 √ null
name sysname 256 √ null
statblob image 2147483647 √ null
maxlen int 4 √ null
rows int 4 √ null

Relationships

Close relationships within degrees of separation