Re: dropping lots of tables at once?

[Christian Mack]

Otis Gospodnetic wrote:
> 
> Hi,
> 
> If there a way to drop more than one table at a time?
> I know I can do:
> mysql> drop table T1,T2,Tn;
> 
> But I'm hoping that there is something that will let me do something like:
> mysql> drop table T*;
> 
> Thanks,
> 
> Otis Gospodnetic

Hi Otis

Wildcards are not allowed for table names.

But you can DROP all tables within one database, by DROPing the database and recreate it
again.

Tschau
Christian

PS: Sorry for the late answer, I was on vacation.