SQL Server: sys.foreign_keys

Find foreign key-primary key relations

select
   schema_name(fkt.schema_id)    schema_fk, fkt.name table_fk,
   schema_name(pkt.schema_id)    schema_pk, pkt.name table_pk,
   --
   fkc.name                      name_fk
from
   sys.foreign_keys   fkc                                              join
   sys.tables         fkt on fkc.parent_object_id     = fkt.object_id  join
   sys.tables         pkt on fkc.referenced_object_id = pkt.object_id
where
-- fkt.name = 'childTable'
   pkt.name = 'ParentTable'

See also