... t1
FULL OUTER JOIN [myDB2].[INFORMATION_SCHEMA].[COLUMNS] t2
ON t1.COLUMN_NAME=t2.COLUMN_NAME
WHERE t2.COLUMN_NAME IS NULL
ORDER BY t1.COLUMN_NAME
-- columns in new database but not in old
SELECT ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.