Get names of Tables which are not there in different Database

Akiii
Posted by Akiii under Sql Server category on | Points: 40 | Views : 892
select t1.name from [dbname1].sys.tables t1
except
select t2.name from [dbname2].sys.tables t2





Thanks and Regards
Akiii

Comments or Responses

Login to post response