--允许系统表更新
sp_configure 'allow updates','1'
go

reconfigure with override
go

update syscolumns
set ColID=(case ColID when 1 then 3 then 1 else ColID end)
where ID=Object_ID('表名')

sp_configure 'allow updates','0'
go
reconfigure with override
go

  

 posted on 2016-09-08 20:55  会飞的金鱼  阅读(1878)  评论(0)    收藏  举报