Query - Foreign Key List

Below
query give us list of Foreign Keys in Database / Foreign Key constraint list in database.

SELECT  obj.name AS foreign_key_Name,

    sch.name AS [schema_name],

    tab1.name AS [table],

    col1.name AS [column],

    tab2.name AS
[referenced_table],

    col2.name AS
[referenced_column]

FROM sys.foreign_key_columns fkc

INNER JOIN sys.objects obj

    ON obj.object_id = fkc.constraint_object_id

INNER JOIN sys.tables tab1

    ON tab1.object_id = fkc.parent_object_id

INNER JOIN sys.schemas sch

    ON tab1.schema_id = sch.schema_id

INNER JOIN sys.columns col1

    ON col1.column_id = parent_column_id AND col1.object_id = tab1.object_id

INNER JOIN sys.tables tab2

    ON tab2.object_id = fkc.referenced_object_id

INNER JOIN sys.columns col2

    ON col2.column_id = referenced_column_id AND col2.object_id = tab2.object_id

where tab2.name='person'

foreign key concept