Compare tables on 2 db sqlserver
Tables in db1 that don't exist in db2:

SELECT name FROM db1.sys.tables
EXCEPT
SELECT name FROM db2.sys.tables
ORDER BY name;


For more elaborate comparisons (like columns, indexes, and data types), don't re-invent the wheel, as there are already tools that solve this problem.* For more info on this in general, see this blog post from ages ago.

Disclaimer: I work for SentryOne.