sys.foreign_key_columns (Transact-SQL)

Applies to: yesSQL Server (all supported versions) YesAzure SQL Database YesAzure SQL Managed Instance yesAzure Synapse Analytics yesParallel Data Warehouse

Contains a row for each column, or set of columns, that comprise a foreign key.

Column name Data type Description
constraint_object_id int ID of the FOREIGN KEY constraint.
constraint_column_id int ID of the column, or set of columns, that comprise the FOREIGN KEY (1..n where n=number of columns).
parent_object_id int ID of the parent of the constraint, which is the referencing object.
parent_column_id int ID of the parent column, which is the referencing column.
referenced_object_id int ID of the referenced object, which has the candidate key.
referenced_column_id int ID of the referenced column (candidate key column).


The visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. For more information, see Metadata Visibility Configuration.

See Also

Object Catalog Views (Transact-SQL)
Catalog Views (Transact-SQL)
Querying the SQL Server System Catalog FAQ