Sunday, August 10, 2008

MySQL : Delete all tables of a database

It seems there's no command to delete all tables of a database. I have
been just dropping the database and creating it again. Does anyone
know any better method ? If you don't have privileges to create/drop
db, my method is not going to work :-)
at

2 comments:

  1. Anonymous2:33 AM

    you could use a PHP script to do it like this one here: http://www.vbulletin.com/forum/showthread.php?t=12279#6

    ReplyDelete
  2. Ketan2:52 AM

    Yeh, script will certainly work. Thank you for the pointer. This will certainly help the readers of this blog.

    ReplyDelete