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?

Can you answer this question?

1 Answers