sys-sysreferences-transact-sql.md

description	sys.sysreferences (Transact-SQL)
title	sys.sysreferences (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/15/2017
ms.prod	sql
ms.prod_service	database-engine, sql-database, synapse-analytics, pdw
ms.reviewer
ms.technology	system-objects
ms.topic	reference
f1_keywords	sys.sysreferences sys.sysreferences_TSQL sysreferences sysreferences_TSQL
dev_langs	TSQL
helpviewer_keywords	sys.sysreferences compatibility view sysreferences system table
ms.assetid	81276f13-202e-4e74-962d-46eb98c98d2e
author	rwestMSFT
ms.author	randolphwest
monikerRange	>=aps-pdw-2016||=azure-sqldw-latest||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current

sys.sysreferences (Transact-SQL)

[!INCLUDE sql-asdbmi-asa-pdw]

Contains mappings of the FOREIGN KEY constraint definitions to the referenced columns within the database.

Important

[!INCLUDEssnoteCompView]

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)	[!INCLUDEssInternalOnly]
refkeys	varbinary(32)	[!INCLUDEssInternalOnly]
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.

See Also

Mapping System Tables to System Views (Transact-SQL)
Compatibility Views (Transact-SQL)