详见:sqlserver修改主键为自增 先删除id字段, 执行下面sql即可: alter table sms_rec add id int IDENTITY (1,1) PRIMARY KEY 转载于:https://www.cnblogs.com/yadongliang/p/9605204.html