syskeys

All databases

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

The columns for syskeys are:

Name	Datatype	Description
id	int	Object ID
type	smallint	Record type. Valid values are: 1 = primary key 2 = foreign key 3 = common key
depid	int null	Dependent object ID
keycnt	int null	Number of non-null keys
size	int null	Reserved
key1 ... key8	smallint null	Column ID
depkey1 ... depkey8	smallint null	Column ID
spare1	smallint	Reserved