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
In SQL Server 2005 and later versions, 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