LinuxQuestions.org

LinuxQuestions.org (/questions/)

- Linux - Software (https://www.linuxquestions.org/questions/linux-software-2/)

- - MySQL (https://www.linuxquestions.org/questions/linux-software-2/mysql-161514/)

Adam H

03-23-2004 05:05 PM

MySQL

Does anyone know of a simple way to drop ALL tables within a DB?

trickykid

03-23-2004 05:17 PM

You could always just delete the DB and recreate it if that's the case... why would you want to do such a thing?

andrewlkho

03-24-2004 05:24 AM

Yup, just drop the database itself with:
DROP database <database>
or is it:
DROP <database>
I never remember...

trickykid

03-24-2004 07:50 AM

Quote:

Originally posted by ho_10
Yup, just drop the database itself with:
DROP database <database>
or is it:
DROP <database>
I never remember...

Its the first one...

DROP DATABASE <database>

All times are GMT -5. The time now is 05:40 AM.