How can I list all foreign keys referencing a given table in SQL Server?

How can I list all foreign keys referencing a given table in SQL Server?

 how to check if columns in table was used as foreign key in other tables

 

Not sure why no one suggested but I use sp_fkeys to query foreign keys for a given table:

EXEC sp_fkeys 'TableName'

You can also specify the schema:

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

Without specifying the schema, the docs state the following:

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.

 

测试了一下，还是很给力的。直接给出一张表A，会直接找到那些用了这张表A的字段作为外键 的其他表。

 

转载于:https://www.cnblogs.com/chucklu/p/10528906.html