List:General Discussion« Previous MessageNext Message »
From:Christian Mack Date:July 15 1999 8:45pm
Subject:Re: dropping lots of tables at once?
View as plain text  
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.

Thread
dropping lots of tables at once?Otis Gospodnetic8 Jul
  • Re: dropping lots of tables at once?Christian Mack16 Jul