sysindexes

#

Column

Datatype

Len

Prec

Scale

Null

Default

Rule

Comments

1

name

longsysname

255

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

status3

smallint

2

No

8

status2

smallint

2

No

9

ipgtrips

int

4

No

10

first

int

4

No

11

root

int

4

No

12

distribution

int

4

No

13

usagecnt

smallint

2

No

14

segment

smallint

2

No

15

status

smallint

2

No

16

maxrowsperpage

smallint

2

No

17

minlen

smallint

2

No

18

maxlen

smallint

2

No

19

maxirow

smallint

2

No

20

keycnt

smallint

2

No

21

keys1

varbinary

255

Yes

22

keys2

varbinary

255

Yes

23

soid

tinyint

1

No

24

csid

tinyint

1

No

25

base_partition

int

4

Yes

26

fill_factor

smallint

2

Yes

27

res_page_gap

smallint

2

Yes

28

exp_rowsize

smallint

2

Yes

29

keys3

varbinary

255

Yes

30

identitygap

int

4

Yes

31

crdate

datetime

8

Yes

32

partitiontype

smallint

2

Yes

33

conditionid

int

4

Yes