Please help with subject.
why not just drop the db and recreate it?
if you can do it with php, just do a 'SHOW TABLES' query, and loop through it and drop them 1 by 1.
but DROP DATABASE db CREATE DATABASE db
is probably faster.
I'm not MySQL server admin
Then just drop every table seperately.
There is no command to drop all tables because who would ever want to drop all his tables at once?
ok... so someone gave you access to drop tables but not the database that contains those tables???
$result = mysql_query("SHOW TABLES"); while(list($table_name) = mysql_fetch_row($result)) mysql_query("DROP TABLE $table_name");
that will do what you want.
What you also can do is seperate them with a , . Like this:
DROP TABLE tablename1,tablename2,table...
etc...
Bassie
