syskeys

All databases

Description

syskeys contains one row for each primary, foreign, or common key.

Columns

The columns for syskeys are:

Name

Datatype

Description

id

int

Object ID

type

smallint

Record type

depid

int

Dependent object ID

keycnt

int

Number of non-null keys

size

int

Reserved

key1 ... key8

smallint

Column ID

depkey1 ... depkey8

smallint

Column ID

spare1

smallint

Reserved

Indexes

Clustered index On id