Sunday, 19 February 2017

Two Data Base Difference Table List

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