Some useful TSQL for dropping all of the tables in a database:
exec sp_MSforeachtable "DROP TABLE ? PRINT '? dropped'"
The only problem with it is, it doesn't take account of foreign key constraints therefore it may fail. If you run it a number of times though, it should be able to delete the majority of the tables.
