sysindexes

#

Column

Datatype

Len

Prec

Scale

Null

Default

Rule

Comments

1

name

sysname

30

Yes

2

id

int

4

No

3

indid

smallint

2

No

4

doampg

int

4

No

5

ioampg

int

4

No

6

oampgtrips

int

4

No

7

status2

smallint

2

No

8

ipgtrips

int

4

No

9

first

int

4

No

10

root

int

4

No

11

distribution

int

4

No

12

usagecnt

smallint

2

No

13

segment

smallint

2

No

14

status

smallint

2

No

15

maxrowsperpage

smallint

2

No

16

minlen

smallint

2

No

17

maxlen

smallint

2

No

18

maxirow

smallint

2

No

19

keycnt

smallint

2

No

20

keys1

varbinary

255

Yes

21

keys2

varbinary

255

Yes

22

soid

tinyint

1

No

23

csid

tinyint

1

No

24

base_partition

int

4

Yes

25

fill_factor

smallint

2

Yes

26

res_page_gap

smallint

2

Yes

27

exp_rowsize

smallint

2

Yes

28

keys3

varbinary

255

Yes

29

identitygap

int

4

Yes

30

crdate

datetime

8

Yes

Name

Attributes

Segment

Columns

sysindexes

unique
clustered

system

id, indid

#

Columns

1

id
indid

1

sp_commonkey references table sysobjects.
Column id to sysobjects.id

2

sp_commonkey references table syssegments.
Column segment to syssegments.segment

#

User/Group

Protect-Type

Action

Column Mask

Grantor

1

public

grant

select

All

dbo