Jasinski Technical Wiki


Home Page
All Pages

Quick Search
Advanced Search »

Contributor Links

Create a new Page
File Management
Your Profile

Other Wiki Sections



sysforeignkeys System Tables - SQL Server 2000

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 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.

ScrewTurn Wiki version Some of the icons created by FamFamFam. Except where noted, all contents Copyright © 1999-2023, Patrick Jasinski.