批量清除表内容

本文来自优快云博客，转载请标明出处：http:


//


blog.youkuaiyun.com


/


htl258


/


archive


/


2009


/


07


/


16


/


4352355


.aspx

 

--批量清除表内容： --1.禁用外键约束

DECLARE c1 cursor for select 'alter table ['+ object_name(parent_obj) + '] nocheck constraint ['+name+']; ' from sysobjects where xtype = 'F' open c1 declare @c1 varchar(8000) fetch next from c1 into @c1 while(@@fetch_status=0) begin exec(@c1) fetch next from c1 into @c1 end close c1 deallocate c1

--2.清除表内容 DECLARE c2 cursor for select 'truncate table ['+name +']; ' from sysobjects where xtype = 'u' open c2 declare @c2 varchar(8000) fetch next from c2 into @c2 while(@@fetch_status=0) begin exec(@c2) fetch next from c2 into @c2 end close c2 deallocate c2

--3.启用外键约束 DECLARE c1 cursor for select 'alter table ['+ object_name(parent_obj) + '] check constraint ['+name+']; ' from sysobjects where xtype = 'F' open c1 declare @c1 varchar(8000) fetch next from c1 into @c1 while(@@fetch_status=0) begin exec(@c1) fetch next from c1 into @c1 end close c1 deallocate c1