SQL Server:更改选定列的排序。

In SQL Server how to change a collation of only selected columns? Is there a way to do that using SQL Server Management Studio?

在SQL Server中，如何更改仅选中列的排序?有使用SQL Server Management Studio实现这一点的方法吗?

I was googling around but what I found where instructions how to change collation of a database not a specific column.

我在谷歌上搜索了一下，但是我找到了如何更改数据库排序的指令，而不是特定的列。

EDIT:

编辑:

So I found this bit of SQL to change column's collation:

所以我找到了这个SQL来改变列的排序:

ALTER TABLE MyTable 
   ALTER COLUMN Column1 [TYPE] COLLATE [NewCollation]

Still is there a way to do that using SQL Server Management Studio?

还有一种方法可以使用SQL Server Management Studio吗?

1 个解决方案

#1

Right-click on table name and choose Design. Then select column and go to Collation in column properties tab (inside Table Designer group).

右键单击表名并选择Design。然后选择column并转到column properties选项卡(表设计器组内部)中的Collation。