TechNet
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize
This documentation is archived and is not being maintained.

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

Show:
© 2016 Microsoft