最近用godaddy的空間，由于系統(tǒng)里面的表多，一個(gè)個(gè)的刪除很麻煩，就網(wǎng)上搜集了一下解決方法。

給大家分享一下：

?

?? 1.批量刪除存儲(chǔ)過(guò)程? declare @procName varchar(500)

????? declare cur cursor

??????????? for select [name] from sys.objects where type = 'p'

????? open cur

????? fetch next from cur into @procName

????? while @@fetch_status = 0

????? begin

??????????? if @procName <> 'DeleteAllProcedures'

????????????????? exec('drop procedure ' + @procName)

????????????????? fetch next from cur into @procName

????? end

????? close cur

????? deallocate cur
2，批量刪除外鍵

DECLARE c1 cursor for
??? select 'alter table ['+ object_name(parent_obj) + '] drop 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
3.批量刪除表

DECLARE c2 cursor for
??? select 'drop 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
--批量清除表內(nèi)容：

--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.清除表內(nèi)容
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
?

?

?

利用sql批量刪除表，存儲(chǔ)過(guò)程。