Quick Search

Advanced Search »

Discuss (0) History

sysforeignkeys System Tables - SQL Server 2000

RSS

Modified on Fri, May 01, 2009, 10:55 AM by Administrator Categorized as SQL Server System Tables

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.

Jasinski Technical Wiki