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

JDP

[SQL] 純文本查看 複制代碼

SELECT name, collation_name
FROM sys.columns
WHERE OBJECT_ID IN ( SELECT OBJECT_ID
FROM sys.objects
WHERE type = 'U'
AND name = 'TableName')

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