sysreferences

All databases

Description

sysreferences contains one row for each referential integrity constraint declared on a table or column.

Columns

The columns for sysreferences are:

Name

Datatype

Description

indexid

smallint

ID of the unique index on referenced columns

constrid

int

Object ID of the constraint from sysobjects

tableid

int

Object ID of the referencing table

reftabid

int

Object ID of the referenced table

keycnt

smallint

Number of columns in the foreign key

status

smallint

Options and indicators

frgndbid

smallint null

Database ID of the database that includes the referenced table (the table with the foreign key)

pmrydbid

smallint

Database ID of the database that includes the referenced table (the table with the primary key)

spare2

int

Reserved

fokey1 ... fokey16

smallint

Column ID of the first to the 16th referencing column

refkey1 ... refkey16

smallint

Column ID of the first to the 16th referenced column

frgndbname

varchar(30) null

Name of the database that includes the referencing table (the table with the foreign key); NULL if the referencing table is in the current database

pmrydbname

varchar(30) null

Name of the database that includes the referenced table (the table with the primary key); NULL if the referenced table is in the current database

The status bit in sysreferences is:

Decimal

Hex

Status

2

0x2

The referential constraint has a match full option

Indexes