一次删除所有表SQL语句如下：
declare @tname varchar(8000)
set @tname=''
select @tname=@tname +'['+ Name + '],' from sysobjects where xtype='U' /*U只是一个标识，这里不是数据库命*/
select @tname='drop table ' + left(@tname,len(@tname)-1)
exec(@tname)
删除所有存储过程的sql语句 用到游标
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
