dcsimg
 

Submitted by: Hannes du Preez(ojdupreez1978@gmail.com)

Thursday Sep 13th 2018 by Hannes du Preez

Language: SQL, Expertise: Intermediate - Find tables referenced by foreign keys with a script similar to this one.

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]
  );
Home
Mobile Site | Full Site