–增加备份字段
alter Table tableName add columnNameBak bigint ;
–将主键自增字段 赋值到备份字段
update tableNameset columnNameBak = columnName;
–删除主键备份字段约束
ALTER TABLE tableNameDROP CONSTRAINT PK_shoppingcart
–删除主键自增字段
alter Table tableName drop column columnName ;
–修改备份字段名称
–ALTER TABLE tableNameRENAME COLUMN columnNameBak TO columnName;
exec sp_rename ‘tableName.columnName_bak’,’columnName’,’COLUMN’;
–字段设置为非空
alter table tableNamealter COLUMN columnName bigint not null;
–创建主键约束
ALTER Table tableNameADD CONSTRAINT pk_columnName PRIMARY KEY (columnName)