IF OBJECT_ID('tempdb..#UntrustedFK') IS NOT NULL DROP TABLE #UntrustedFK; GO CREATE TABLE [#UntrustedFK] ( [db_name] SYSNAME, [sch_name] SYSNAME, [ent_name] SYSNAME, [fk_name] SYSNAME ); EXECUTE [master].[sys].[sp_MSforeachdb] ' USE [?]; INSERT INTO #UntrustedFK SELECT ''?'' ,SCHEMA_NAME(fk.schema_id) AS [schema] ,[ob].[name] ,[fk].[name] FROM [sys].[foreign_keys] AS fk JOIN [sys].[objects] AS ob ON [fk].[parent_object_id] = [ob].[object_id] WHERE [fk].[is_not_trusted] = 1 and [fk].[is_disabled] = 0 and [fk].[is_not_for_replication] = 0; ' SELECT * FROM [#UntrustedFK] ORDER BY db_name, sch_name, ent_name, fk_name GO