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