SQL Server 查询所有表中字段的Collation类型

SELECT c.object_id, t.name, c.name, c.collation_name

FROM sys.columns c

INNER JOIN sys.tables t ON c.object_id = t.object_id