Drop all tables and stored procedures in a SQL DB

-- drop all tables

EXEC sp_MSforeachtable @command1 = 'DROP TABLE ?'

 

-- drop all stored procedures

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

     Exec('drop procedure ' + @procName)

     Fetch Next From cur Into @procName

 End

 Close cur

 Deallocate cur