syscolumns

#

Column

Datatype

Len

Prec

Scale

Null

Default

Rule

Comments

1

id

int

4

No

2

number

smallint

2

No

3

colid

smallint

2

No

4

status

tinyint

1

No

5

type

tinyint

1

No

6

length

int

4

No

7

offset

smallint

2

No

8

usertype

smallint

2

No

9

cdefault

int

4

No

10

domain

int

4

No

11

name

longsysname

255

No

12

printfmt

varchar

255

Yes

13

prec

tinyint

1

Yes

14

scale

tinyint

1

Yes

15

remote_type

int

4

Yes

16

remote_name

varchar

255

Yes

17

xstatus

int

4

Yes

18

xtype

int

4

Yes

19

xdbid

int

4

Yes

20

accessrule

int

4

Yes

21

status2

int

4

Yes

22

status3

smallint

2

No

23

computedcol

int

4

Yes

24

encrtype

int

4

Yes

25

encrlen

int

4

Yes

26

encrkeyid

int

4

Yes

27

encrkeydb

sysname

30

Yes

28

encrdate

datetime

8

Yes