mysql

[JealY]

Does anyone know a sql query to drop all tables?

Thanks.

 

[LeoCrasher]

Rather than dropping ALL the tables, can't you just drop the database the tables are in. Thereby deleting all the tables anyway?

DROP DBNAME
/Leo

 

[JealY]

Well, it's my website mysql so I can't drop the db.

Anybody know this?


Anyone at all.

 

[LeoCrasher]

I getcha, but you said dropping all tables. Dropping all tables is exactly the same as dropping a DB.

Do you mean you just wish to drop one table?
/Leo

 

[JealY]

Well I wanna drop all tables in a db i'll try droping the db.

Nope, DROP DBNAME didn't work.

 

[LeoCrasher]

...you replace DBNAME with the name of the database :P.

What are you using as your MySQL frontend?

/Leo

 

[JealY]

...you replace DBNAME with the name of the database :P.

What are you using as your MySQL frontend?

/Leo

Well duh, jesus leo give me some credit.

MySQL Admin, or whatever it's called, if that's what you mean, I can't connect to my websites db outside my website.

 

[LeoCrasher]

Using MySQL Admin:

1. Open, connect etc
2. Goto the Catalogs tab
3. Right click the 'Schemata' you wish to delete
4. Click 'Drop Scheme'

Alternatively;
Open the catalog you wish, highlight all the tables (in the right window pane) you wish to delete, right click and then select 'drop table'.

/Leo

 

[JealY]

Hmmm good point, yeah i'll do that. Thanks. Just out of curiosity is there not a query to drop all tables, not the db

I suppose you could make a php file to do it.

 

[LeoCrasher]

I'm going to find the biggest, wettest, scaliest fish and slap you with it. Dropping the DB drops all the tables! :P

The obvious query would be;

DROP TABLE 'tblname1','tblname1','tblname3';

...but thats just plain silly.

/Leo