Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

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

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.