Finding Foreign Key In SQL Server

Here I Will explain how many ways, we can find a foreign key in SQL Server.

Using this query, we can find all the foreign keys in the current database.

select * from sysobjects where type='f' 

Using this query, we can find all the foreign keys in a selected table.

EXEC sp_fkeys 'Catalog' 

Using this query, we can find all the foreign keys in a current database with more information.

SELECT RC.CONSTRAINT_NAME FK_Name  
, KF.TABLE_SCHEMA FK_Schema  
, KF.TABLE_NAME FK_Table  
, KF.COLUMN_NAME FK_Column  
, RC.UNIQUE_CONSTRAINT_NAME PK_Name  
, KP.TABLE_SCHEMA PK_Schema  
, KP.TABLE_NAME PK_Table  
, KP.COLUMN_NAME PK_Column  
, RC.MATCH_OPTION MatchOption  
, RC.UPDATE_RULE UpdateRule  
, RC.DELETE_RULE DeleteRule  
FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS RC  
JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE KF ON RC.CONSTRAINT_NAME = KF.CONSTRAINT_NAME  
JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE KP ON RC.UNIQUE_CONSTRAINT_NAME = KP.CONSTRAINT_NAME