A very cool trick which I have previously not shared on my blog regarding how to list all the foreign key relationship of table with the help of Stored Procedure sp_fkeys.
Here is a quick script how you can use stored procedure sp_fkeys to list all the foreign key relationship. This stored procedure takes a minimum of two parameters a) name of the table, b) name of the schema.
EXEC sp_fkeys @pktable_name = N'Employee',
@pktable_owner = N'HumanResources';
Here is the output generated from the script listed above:
Here is an alternate way to list the keys as well – Two Methods to Retrieve List of Primary Keys and Foreign Keys of Database.
Reference: Pinal Dave (https://blog.sqlauthority.com)
sp_fkeys doesn’t seem to find composite keys. Any Idea how to find those as well?