Sql 语句删除数据库中所有表

declare @tname varchar (8000)

set @tname= ''

select @tname=@tname + Name + ',' from sysobjects where xtype= '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

转载于:https://www.cnblogs.com/beidao/archive/2012/10/25/2739335.html