>>>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
It is in SQL Server 2000 also.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
