Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Collapse the table of content
Expand the table of content


SQL Server 2000

Contains information regarding the FOREIGN KEY constraints that are in table definitions. This table is stored in each database.

Column name Data type Description
constid int ID of the FOREIGN KEY constraint.
fkeyid int Object ID of the table with the FOREIGN KEY constraint.
rkeyid int Object ID of the table referenced in the FOREIGN KEY constraint.
fkey smallint ID of the referencing column.
rkey smallint ID of the referenced column.
keyno smallint Position of the column in the reference column list.

© 2015 Microsoft