... AS [DB1_ColumnMaxLength],
t2.CHARACTER_MAXIMUM_LENGTH AS [DB2_ColumnMaxLength],
t1.COLLATION_NAME AS [DB1_ColumnCollation],
t2.COLLATION_NAME AS [DB2_ColumnCollation]
FROM [myDB1].[INFORMATION_SCHEMA].[COLUMNS] ...
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.