sys.foreign_key_columns

objects

#objects#catalog-view

Description

Analytics Platform System (PDW) SQL database in Microsoft Fabric Contains a row for each column, or set of columns, that comprise a foreign key.

Syntax

SELECT fk.name
AS
ForeignKeyName
, t_parent.name
AS
ParentTableName
, c_parent.name
AS
ParentColumnName
, t_child.name
AS
ReferencedTableName
, c_child.name
AS
ReferencedColumnName
FROM sys.foreign_keys fk
INNER
JOIN sys.foreign_key_columns fkc

Examples

Example 1

SELECT fk.name
AS
ForeignKeyName
, t_parent.name
AS
ParentTableName
, c_parent.name
AS
ParentColumnName
, t_child.name
AS
ReferencedTableName
, c_child.name
AS
ReferencedColumnName
FROM sys.foreign_keys fk
INNER
JOIN sys.foreign_key_columns fkc