23 Aug, 2022
SQL SERVER : T-SQL query to show all table columns and their collation 0 (0)
MSSQL, T-SQL Scripts ,

Below query can be used to list all table columns and their corresponding collation.

USE <DB_NAME/** replace your database name here **/
GO
SELECT @@servername 'Server',db_name() 'Database',
t.name as "TableName",
c.name as "ColumnName",
c.Collation_name
FROM sys.columns c INNER JOIN … Read the rest