Get Foreign Key related details for the Table

Author posted by Jitendra on Posted on under category Categories SQL, SQL Server and tagged as Tags , with Leave a comment on Get Foreign Key related details for the Table

Get Foreign Key related details for the Table in SQL Server

Getting the foreign key detail of particular table is the most common tasks used by DBA or database developers. every time go to left panel, select table and right click to get foreign key details wastes most of the time.

So below is the script which will return the detail about foreign key of particular table:

SELECT f.name AS ForeignKey,
OBJECT_NAME(f.parent_object_id) AS TableName,
COL_NAME(fc.parent_object_id,
fc.parent_column_id) AS ColumnName,
OBJECT_NAME (f.referenced_object_id) AS ReferenceTableName,
COL_NAME(fc.referenced_object_id,
fc.referenced_column_id) AS ReferenceColumnName
FROM sys.foreign_keys AS f
INNER JOIN sys.foreign_key_columns AS fc
ON f.OBJECT_ID = fc.constraint_object_id
WHERE OBJECT_NAME(f.parent_object_id)='TABLE_NAME'

Related posts