sqlserver修改主键列类型,先要删除主键约束,然后修改字段类型,最后再设置列为主键
sql语句
alter table Users drop PK_USERS
alter table Users alter column id varchar(60) not null
alter table Users add constraint PK_USERS primary key(id)
sqlserver修改主键列类型,先要删除主键约束,然后修改字段类型,最后再设置列为主键
sql语句
alter table Users drop PK_USERS
alter table Users alter column id varchar(60) not null
alter table Users add constraint PK_USERS primary key(id)