
August 8, 2009 08:30 by
Simon
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.
fb870448-c6ce-472a-9b48-ae5437ca962d|0|.0