An easy query:
SELECT name
FROM DB1.sys.[tables] t
WHERE [type] = 'U'
INTERSECT
SELECT name
FROM DB2.sys.[tables] t
WHERE [type] = 'U';
It doesn't take the schema into account.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP