修复自增列语句修复索引语句

xushugang007

于 2024-09-29 08:28:21 发布

阅读量18

点赞数 1

文章标签：数据库

本文链接：https://blog.csdn.net/xushugang007/article/details/142626059

版权

--修复自增列语句：
use hbposv8
go
declare @tablename varchar(100)
declare  test_cur cursor for
select object_name(id) from syscolumns 
where status=128
open test_cur
fetch test_cur into @tablename
while @@fetch_status=0
begin   
   DBCC CHECKIDENT (@tablename, RESEED)   
   fetch test_cur into @tablename
end
close test_cur
deallocate test_cur
go
---修复索引
use hbposv8
go
declare @tablename varchar(100)
declare  test_cur cursor for
select object_name(id) from sysobjects 
where type ='U'
open test_cur
fetch test_cur into @tablename
while @@fetch_status=0
begin   
   DBCC DBREINDEX(@tablename)
   fetch test_cur into @tablename
end
close test_cur
deallocate test_cur
go