Applies to: SQL Server (all supported versions) Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Parallel Data Warehouse
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).|
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.