alter table tableName drop constraint pk_tableName
go
ALTER TABLE tableName ALTER COLUMN columnName varchar(20) COLLATE Chinese_PRC_CS_AS not null
go
alter table tableName add constraint pk_tableNameprimary key(columnA,columnB...)
go
alter table tableName drop constraint pk_tableName
go
ALTER TABLE tableName ALTER COLUMN columnName varchar(20) COLLATE Chinese_PRC_CS_AS not null
go
alter table tableName add constraint pk_tableNameprimary key(columnA,columnB...)
go