sysreferences System Table - SQL Server 2000

Contains mappings of FOREIGN KEY constraint definitions to the referenced columns. This table is stored in each database.

Column nameData typeDescription
constidintID of the FOREIGN KEY constraint
fkeyidintID of the referencing table
rkeyidintID of the referenced table
rkeyindidsmallintIndex ID of the unique index on the referenced table covering the referenced key-columns
keycntsmallintNumber of columns in the key
forkeysvarbinary(32)For internal use only
refkeysvarbinary(32)For internal use only
fkeydbidsmallintReserved
rkeydbidsmallintReserved
fkey1smallintColumn ID of the referencing column
fkey2smallintColumn ID of the referencing column
fkey3smallintColumn ID of the referencing column
fkey4smallintColumn ID of the referencing column
fkey5smallintColumn ID of the referencing column
fkey6smallintColumn ID of the referencing column
fkey7smallintColumn ID of the referencing column
fkey8smallintColumn ID of the referencing column
fkey9smallintColumn ID of the referencing column
fkey10smallintColumn ID of the referencing column
fkey11smallintColumn ID of the referencing column
fkey12smallintColumn ID of the referencing column
fkey13smallintColumn ID of the referencing column
fkey14smallintColumn ID of the referencing column
fkey15smallintColumn ID of the referencing column
fkey16smallintColumn ID of the referencing column
rkey1smallintColumn ID of the referenced column
rkey2smallintColumn ID of the referenced column
rkey3smallintColumn ID of the referenced column
rkey4smallintColumn ID of the referenced column
rkey5smallintColumn ID of the referenced column
rkey6smallintColumn ID of the referenced column
rkey7smallintColumn ID of the referenced column
rkey8smallintColumn ID of the referenced column
rkey9smallintColumn ID of the referenced column
rkey10smallintColumn ID of the referenced column
rkey11smallintColumn ID of the referenced column
rkey12smallintColumn ID of the referenced column
rkey13smallintColumn ID of the referenced column
rkey14smallintColumn ID of the referenced column
rkey15smallintColumn ID of the referenced column
rkey16smallintColumn ID of the referenced column