Drop Database doesn't drop a table?

[woohahee]

Ok this has got me stumped, I write the following in the SQL Query Analyser:

Drop Database richard

I then run the SQL script I generated before I dropped the database to recreate database richard.

However it falls over because the error messages say that I cannot create one of the tables as it already exists? Now surely if you've dropped a database there shouldn't be any tables left when you run a script to recreate it.

 

[carrr]

Sometimes SQL seems to take a bit of time to "sync up" after dropping a table. (Not long, but if you drop and then immediately issue the command to rebuild, it will balk.) I sometimes will 'F5' query analyzer and this seems to speed up the process.