单个字段的collation可以修改吗

使用脚本修改吧，界面也可以 脚本如下： Alter table [表名] Alter column [列名] [列类型] [NOT NULL或者 NULL]  alter table 脚本很丰富，可以查看MS SQL的帮助，新手做baidu任务，给个满意吧 ALTER TABLE [ database_name . [ schema_name ] . | schema_name . ] table_name {  ALTER COLUMN column_name  {  [ type_schema_name. ] type_name [ ( { precision [ , scale ]  | max | xml_schema_collection } ) ]  [ COLLATE collation_name ]  [ NULL | NOT NULL ]  | {ADD | DROP }  { ROWGUIDCOL | PERSISTED | NOT FOR REPLICATION | SPARSE }  }  | [ WITH { CHECK | NOCHECK } ]   | ADD  {  <column_definition>  | <computed_column_definition>  | <table_constraint>  | <column_set_definition>  } [ ,...n ]   | DROP  {  [ CONSTRAINT ] constraint_name  [ WITH ( <drop_clustered_constraint_option> [ ,...n ] ) ]  | COLUMN column_name  } [ ,...n ]   | [ WITH { CHECK | NOCHECK } ] { CHECK | NOCHECK } CONSTRAINT  { ALL | constraint_name [ ,...n ] }   | { ENABLE | DISABLE } TRIGGER  { ALL | trigger_name [ ,...n ] }   | { ENABLE | DISABLE } CHANGE_TRACKING  [ WITH ( TRACK_COLUMNS_UPDATED = { ON | OFF } ) ]   | SWITCH [ PARTITION source_partition_number_expression ]  TO target_table  [ PARTITION target_partition_number_expression ]   | SET ( FILESTREAM_ON = { partition_scheme_name | filegroup |  "default" | "NULL" } )   | REBUILD  [ [PARTITION = ALL]  [ WITH ( <rebuild_option> [ ,...n ] ) ]  | [ PARTITION = partition_number  [ WITH ( <single_partition_rebuild_option> [ ,...n ] ) ]  ]  ]   | (<table_option>) } [ ; ]  <column_set_definition> ::=  column_set_name XML COLUMN_SET FOR ALL_SPARSE_COLUMNS  <drop_clustered_constraint_option> ::=  {  MAXDOP = max_degree_of_parallelism  | ONLINE = {ON | OFF }  | MOVE TO { partition_scheme_name ( column_name ) | filegroup  | "default" }  } <table_option> ::=  {  SET ( LOCK_ESCALATION = { AUTO | TABLE | DISABLE } )  }  <single_partition_rebuild__option> ::= {  SORT_IN_TEMPDB = { ON | OFF }  | MAXDOP = max_degree_of_parallelism  | DATA_COMPRESSION = { NONE | ROW | PAGE} } }

答案来源于网络，供您参考