Find Tables Referenced by Foreign Keys

You can easily find tables referenced by foreign keys with a script similar to the following:

SELECT [table] = s.name + N'.' + t.name  FROM sys.tables AS t  INNER JOIN sys.schemas AS s  ON t.[schema_id] = s.[schema_id]  WHERE EXISTS  (    SELECT 1 FROM sys.foreign_keys AS fk      WHERE fk.referenced_object_id = t.[object_id]  );
Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: