Home > Database > Find Tables With Foreign Key Constraint

Find Tables With Foreign Key Constraint

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.referenced_object_id) =‘table_name’

Advertisements
Categories: Database
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: