syskeys

#

Column

Datatype

Len

Prec

Scale

Null

Default

Rule

Comments

1

id

int

4

No

2

type

smallint

2

No

3

depid

int

4

Yes

4

keycnt

int

4

Yes

5

size

int

4

Yes

6

key1

smallint

2

Yes

7

key2

smallint

2

Yes

8

key3

smallint

2

Yes

9

key4

smallint

2

Yes

10

key5

smallint

2

Yes

11

key6

smallint

2

Yes

12

key7

smallint

2

Yes

13

key8

smallint

2

Yes

14

depkey1

smallint

2

Yes

15

depkey2

smallint

2

Yes

16

depkey3

smallint

2

Yes

17

depkey4

smallint

2

Yes

18

depkey5

smallint

2

Yes

19

depkey6

smallint

2

Yes

20

depkey7

smallint

2

Yes

21

depkey8

smallint

2

Yes

22

spare1

smallint

2

No

Name

Attributes

Segment

Columns

syskeys

clustered

system

id

#

Columns

1

id

1

sp_foreignkey references table sysobjects.
Column id to sysobjects.id

1

sp_commonkey references table sysobjects.
Column depid to sysobjects.id

1

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

2

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

#

User/Group

Protect-Type

Action

Column Mask

Grantor

1

public

grant

select

All

dbo