sql - 如何列出引用 SQL Server 中给定表的所有外键？

Question

我需要删除 SQL Server 数据库中高度引用的表。如何获取删除表时需要删除的所有外键约束的列表？

(SQL 答案比在管理工作室的 GUI 中单击“有关”更好。)

Answer 1

不知道为什么没有人建议，但我使用 sp_fkeys 来查询给定表的外键:

EXEC sp_fkeys 'TableName'

您还可以指定架构:

EXEC sp_fkeys @pktable_name = 'TableName', @pktable_owner = 'dbo'

如果不指定架构，docs陈述以下内容:

If pktable_owner is not specified, the default table visibility rules of the underlying DBMS apply.

In SQL Server, if the current user owns a table with the specified name, that table's columns are returned. If pktable_owner is not specified and the current user does not own a table with the specified pktable_name, the procedure looks for a table with the specified pktable_name owned by the database owner. If one exists, that table's columns are returned.