Sunday, 19 February 2017

Two Data Base Difference Column Data Type

SELECT 'DBFirst' AS DbName,
  C1.TABLE_NAME, 
       C1.COLUMN_NAME, 
       C1.DATA_TYPE, 
  '      <=>' AS DIFFERENCE,
  'DBSecond' AS DbName,
       C2.TABLE_NAME, 
       C2.DATA_TYPE, 
       C2.COLUMN_NAME 
FROM   DBFirst.[INFORMATION_SCHEMA].[COLUMNS] C1 
       INNER JOIN DBSecond.[INFORMATION_SCHEMA].[COLUMNS] C2 
               ON C1.COLUMN_NAME = C2.COLUMN_NAME 
WHERE  1 = 1 
       AND C1.TABLE_NAME = C2.TABLE_NAME 
       AND C1.DATA_TYPE <> C2.DATA_TYPE 

No comments:

Post a Comment