 <p>Code -</p> <pre><code>drop table #a drop table #b select * into #a from [databasename1].information_schema.columns a --where table_name = 'aaa' select * into #b from [databasename2].information_schema.columns b -- add linked server name and db as needed --where table_name = 'bbb' select distinct( a.table_name), b.TABLE_SCHEMA+ '.' + (b.table_name) TableName,b.TABLE_CATALOG DatabaseName from #a a right join #b b on a.TABLE_NAME = b.TABLE_NAME and a.TABLE_SCHEMA = b.TABLE_SCHEMA where a.table_name is null-- and a.table_name not like '%sync%' </code></pre>