查看Table內各欄位的定序(Collation)

JDP

[mw_shl_code=sql,true]SELECT name, collation_name
FROM sys.columns
WHERE OBJECT_ID IN ( SELECT OBJECT_ID
FROM sys.objects
WHERE type = 'U'
AND name = 'TableName')[/mw_shl_code]

Reference: https://blog.sqlauthority.com/20 ... olumn-t-sql-script/