精选优质文档-倾情为你奉上-修改标识列标记,慎用!慎用!慎用!-允许对系统表进行更新exec sp_configure allow updates,1 reconfigure with override-查看标识列,name为具体表的字段名select * from syscolumns where id = object_id(t_test) and colstat = 1-取消标识列标记update syscolumns set colstat = 0 where id = object_id(t_test) and colstat = 1-查看非标识列select * from syscolumns where id = object_id(t_test) and colstat = 0-恢复标识列标记,注意必须增加条件 name =,否则所有列都变成标识列update syscolumns set colstat = 1 where id = object_id(t_test) and