郑德才博客

MSSql删除数据库中所有表（只是表）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