>>You could use sp_MSForEachTable:
>>

>>USE YourDataBase
>>sp_MsForEachTable 'DROP TABLE ?'
>>

>
>Should I just type the 2nd line as is in the Query window? The database is already the default. When I tried that, it says "Could not find stored procedure 'sp_MsforEachTable'.

It exists in SQL2005 and later, probably you're using 2000.
I think just adding a "if exists ... Drop Table" line before each create would do it just fine.
Cetin