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