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

Question

Aryan Kumar · Answer

There are a few ways to list all foreign keys referencing a table in SQL Server. Here are two of the most common methods:
Using the sys.foreign_keys table
The sys.foreign_keys table contains a list of all foreign keys in a database. You can use this table to list all foreign keys referencing a table by using the following query:
SQL
SELECT *
FROM sys.foreign_keys
WHERE referenced_table_name = 'table_name';
For example, the following code will list all foreign keys referencing the 
Customers table:
SQL
SELECT *
FROM sys.foreign_keys
WHERE referenced_table_name = 'Customers';
Using the sp_fkeys stored procedure
The sp_fkeys stored procedure is a system stored procedure that can be used to list all foreign keys referencing a table. To use the
sp_fkeys stored procedure, you need to specify the name of the table that you want to list the foreign keys for. For example, the following code will list all foreign keys referencing the
Customers table:
SQL
EXEC sp_fkeys 'Customers';
The sp_fkeys stored procedure will return a list of all foreign keys referencing the
Customers table. The list will include the name of the foreign key, the name of the referenced table, and the name of the column in the referenced table that is referenced by the foreign key.

forum

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

Revati S Misra

Can you answer this question?

1 Answers

Liked By