systypes

#

Column

Datatype

Len

Prec

Scale

Null

Default

Rule

Comments

1

uid

int

4

No

2

usertype

smallint

2

No

3

variable

bit

1

No

4

allownulls

bit

1

No

5

type

tinyint

1

No

6

length

int

4

No

7

tdefault

int

4

No

8

domain

int

4

No

9

name

sysname

30

No

10

printfmt

varchar

255

Yes

11

prec

tinyint

1

Yes

12

scale

tinyint

1

Yes

13

ident

tinyint

1

Yes

14

hierarchy

tinyint

1

Yes

15

xtypeid

int

4

Yes

16

xdbid

int

4

Yes

17

accessrule

int

4

Yes

Name

Attributes

Segment

Columns

systypes

unique
clustered

system

name

ncsystypes

unique

system

usertype

#

Columns

1

name

1

sp_commonkey references table sysusers.
Column uid to sysusers.uid

1

sp_commonkey coming from table syscolumns.
syscolumns.type to column type

2

sp_commonkey coming from table syscolumns.
syscolumns.usertype to column usertype

3

sp_commonkey coming from table syscolumns.
syscolumns.domain to column domain

4

sp_commonkey coming from table syscolumns.
syscolumns.cdefault to column tdefault

#

User/Group

Protect-Type

Action

Column Mask

Grantor

1

public

grant

select

All

dbo