Thanks for the pointers. I forgot to mention I had looked the on-line MySQL documents about 'drop table' before I posted my questions. Unfortunately, neither the previous discussions on the subject nor the document provided the anwsers I've been looking for. Enumerating all the tables to be dropped is not acceptable to us. Thanks anyway.
Bing > > On 5 Jan 2004, at 19:58, Bing Du wrote: > >> Greetings, >> >> Say, one database has a lot of tables. How can I drop some of them >> all at >> once assuming their names follow some pattern like tbl_*? >> >> Thanks in advance for any ideas, >> > > Take a look at a very similar thread here... > > http://lists.mysql.com/mysql/156593 > > The best answer being 'look at the documentation'... > > http://www.mysql.com/doc/en/DROP_TABLE.html > > > HTH > Steve. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]