Relacionamento entre tabelas

SELECT b.name AS 'Tabela' ,
a.name AS 'Chave Extrangeira' ,
c.name AS 'Tabela Pai'
FROM sys.foreign_keys A INNER JOIN sys.objects B ON a.parent_object_id = b.object_id
JOIN sys.objects C ON c.object_id = a.referenced_object_id ORDER BY b.name ASC