SELECT
T1.TABLE_NAME,
'DataBase First' AS DBNAME
FROM
DataBase First.[INFORMATION_SCHEMA].[TABLES] T1
WHERE
TABLE_NAME NOT IN
(
SELECT
T2.TABLE_NAME
FROM
DataBase Second.[INFORMATION_SCHEMA].[TABLES] T2
)
No comments:
Post a Comment