sysobjects

#

Column

Datatype

Len

Prec

Scale

Null

Default

Rule

Comments

1

name

sysname

30

No

2

id

int

4

No

3

uid

int

4

No

4

type

char

2

No

5

userstat

smallint

2

No

6

sysstat

smallint

2

No

7

indexdel

smallint

2

No

8

schemacnt

smallint

2

No

9

sysstat2

int

4

No

10

crdate

datetime

8

No

11

expdate

datetime

8

No

12

deltrig

int

4

No

13

instrig

int

4

No

14

updtrig

int

4

No

15

seltrig

int

4

No

16

ckfirst

int

4

No

17

cache

smallint

2

No

18

audflags

int

4

Yes

19

objspare

int

4

No

20

versionts

binary

12

Yes

21

loginame

varchar

30

Yes

Name

Attributes

Segment

Columns

sysobjects

unique
clustered

system

id

ncsysobjects

unique

system

name, uid

#

Columns

1

id

1

sp_foreignkey coming from table syskeys.
syskeys.id to column id

1

sp_commonkey references table sysprocedures.
Column id to sysprocedures.id

2

sp_commonkey references table sysprotects.
Column id to sysprotects.id

3

sp_commonkey references table sysusers.
Column uid to sysusers.uid

1

sp_commonkey coming from table sysindexes.
sysindexes.id to column id

2

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

3

sp_commonkey coming from table syscomments.
syscomments.id to column id

4

sp_commonkey coming from table sysdepends.
sysdepends.id to column id

5

sp_commonkey coming from table syskeys.
syskeys.depid to column id

#

User/Group

Protect-Type

Action

Column Mask

Grantor

1

public

grant

select

0x3BFFFE

dbo

2

sso_role

grant

select

All

dbo