--修改标识列标记,慎用!慎用!慎用!--允许对系统表进行更新execsp_configure'allowupdates',1reconfigurewithoverride--查看标识列,name为具体表的字段名select*fromsyscolumnswhereid=object_id('t_test')andcolstat=1--取消标识列标记updatesyscolumnssetcolstat=0whereid=object_id('t_test')andcolstat=1--查看非标识列select*fromsyscolumnswhereid=object_id('t_test')andcolstat=0--恢复标识列标记,注意必须增加条件name='',否则所有列都变成标识列updatesyscolumnssetcolstat=1whereid=object_id('t_test')andcolstat=0andname='ID'--禁止对系统表进行更新execsp_configure'allowupdates',0reconfigurewithoverride