Relacionar chaves extrageiras

Getting your Trinity Audio player ready...

Esse script relaciona as tabelas existentes em um banco de dados com o nome da chave extrangeira e a “tabela pai”

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

Leave a Reply

Your email address will not be published. Required fields are marked *