34,594
社区成员
发帖
与我相关
我的任务
分享
-- 获取损坏表的object id.
select id
from test.dbo.sysobjects
where xtype='U' and name='a'
-- 从系统表删除表a
delete test.dbo.sysobjects where id=[object id] --> 将以上查询的id值代入[object id]
delete test.dbo.sysindexes where id=[object id]
delete test.dbo.syscolumns where id=[object id]