Thursday, March 22, 2012

Find Database Table's Foreign key mappings in SQL Server

The Foreign key mapping is stored in system database in SQL server, here is the query to find all the mappings.

Use <Database Name>
GO

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



No comments:

Post a Comment