Share via


sys.foreign_key_columns (Transact-SQL)

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).

Permissions

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

Reference

Object Catalog Views (Transact-SQL)

Catalog Views (Transact-SQL)

Concepts

Querying the SQL Server System Catalog FAQ