SQL 修改表中字段的顺序

--允许系统表更新
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