.png)
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). |
Reference
Object Catalog Views (Transact-SQL)Catalog Views (Transact-SQL)
