devxlogo

Find Tables Referenced by Foreign Keys

Find Tables Referenced by Foreign Keys

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

SELECT [table “” not found /]

= 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] );

devx-admin

Share the Post: