Transact-SQL Reference
sysreferences
Contains mappings of FOREIGN KEY constraint definitions to the referenced columns. This table is stored in each database.
Column name | Data type | Description |
---|---|---|
constid | int | ID of the FOREIGN KEY constraint |
fkeyid | int | ID of the referencing table |
rkeyid | int | ID of the referenced table |
rkeyindid | smallint | Index ID of the unique index on the referenced table covering the referenced key-columns |
keycnt | smallint | Number of columns in the key |
forkeys | varbinary(32) | For internal use only |
refkeys | varbinary(32) | For internal use only |
fkeydbid | smallint | Reserved |
rkeydbid | smallint | Reserved |
fkey1 | smallint | Column ID of the referencing column |
fkey2 | smallint | Column ID of the referencing column |
fkey3 | smallint | Column ID of the referencing column |
fkey4 | smallint | Column ID of the referencing column |
fkey5 | smallint | Column ID of the referencing column |
fkey6 | smallint | Column ID of the referencing column |
fkey7 | smallint | Column ID of the referencing column |
fkey8 | smallint | Column ID of the referencing column |
fkey9 | smallint | Column ID of the referencing column |
fkey10 | smallint | Column ID of the referencing column |
fkey11 | smallint | Column ID of the referencing column |
fkey12 | smallint | Column ID of the referencing column |
fkey13 | smallint | Column ID of the referencing column |
fkey14 | smallint | Column ID of the referencing column |
fkey15 | smallint | Column ID of the referencing column |
fkey16 | smallint | Column ID of the referencing column |
rkey1 | smallint | Column ID of the referenced column |
rkey2 | smallint | Column ID of the referenced column |
rkey3 | smallint | Column ID of the referenced column |
rkey4 | smallint | Column ID of the referenced column |
rkey5 | smallint | Column ID of the referenced column |
rkey6 | smallint | Column ID of the referenced column |
rkey7 | smallint | Column ID of the referenced column |
rkey8 | smallint | Column ID of the referenced column |
rkey9 | smallint | Column ID of the referenced column |
rkey10 | smallint | Column ID of the referenced column |
rkey11 | smallint | Column ID of the referenced column |
rkey12 | smallint | Column ID of the referenced column |
rkey13 | smallint | Column ID of the referenced column |
rkey14 | smallint | Column ID of the referenced column |
rkey15 | smallint | Column ID of the referenced column |
rkey16 | smallint | Column ID of the referenced column |