Jasinski Technical Wiki

Navigation

Home Page
Index
All Pages

Quick Search
»
Advanced Search »

Contributor Links

Create a new Page
Administration
File Management
Login/Logout
Your Profile

Other Wiki Sections

Software

PoweredBy

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 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 3.0.1.400. Some of the icons created by FamFamFam. Except where noted, all contents Copyright © 1999-2024, Patrick Jasinski.