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

sysname

30

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

30

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

Name

Attributes

Segment

Columns

syscolumns

unique
clustered

system

id, number, colid

#

Columns

1

id
number
colid

1

sp_commonkey references table syscomments.
Column id to syscomments.id

2

sp_commonkey references table syskeys.
Column id to syskeys.key1

3

sp_commonkey references table syskeys.
Column id to syskeys.depkey1

4

sp_commonkey references table sysobjects.
Column id to sysobjects.id

5

sp_commonkey references table systypes.
Column type to systypes.type

6

sp_commonkey references table systypes.
Column usertype to systypes.usertype

7

sp_commonkey references table systypes.
Column domain to systypes.domain

8

sp_commonkey references table systypes.
Column cdefault to systypes.tdefault

#

User/Group

Protect-Type

Action

Column Mask

Grantor

1

public

grant

select

All

dbo