Get names of Tables which are not there in different Database

Posted by Akiii under Sql Server category on 7/30/2012 | Points: 40 | Views : 1948

select t1.name from [dbname1].sys.tables t1
except
select t2.name from [dbname2].sys.tables t2

Thanks and Regards
Akiii

Bookmark It

Latest Code Snipptes