sysforeignkeys System Tables - SQL Server 2000

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

Column nameData typeDescription
constidintID of the FOREIGN KEY constraint.
fkeyidintObject ID of the table with the FOREIGN KEY constraint.
rkeyidintObject ID of the table referenced in the FOREIGN KEY constraint.
fkeysmallintID of the referencing column.
rkeysmallintID of the referenced column.
keynosmallintPosition of the column in the reference column list.