JDP 發表於 2018-6-6 14:45:19

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

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/2008/12/20/sql-server-change-collation-of-database-column-t-sql-script/
頁: [1]
查看完整版本: 查看Table內各欄位的定序(Collation)