思想很简单:删除自增列然后重建 1 alter table #test drop column id 2 alter table #test add id int identity 转载于:https://www.cnblogs.com/ycyk168/archive/2007/12/03/980423.html