楼主方法有两种:表名TB_Role 自增列rid
1、
select * into # from TB_Role
truncate TB_Role
alter table # drop COLUMN rid
insert TB_Role
select * from #
--drop table #
2、
select r_id=identity(int,1,1),所有列名(不包含r_id) into roy
from TB_Role
drop table TB_Role
EXEC sp_rename 'roy', 'TB_Role'--重命名表