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 :-)

2 comments:

Anonymous said...

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

Ketan said...

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