Dropping all tables from mysql db

[swativ]

how do i drop all my tables from my db without having to name all the tables in the query....any help would be appreciated...thankss

[seansd]

quickest way would be to drop database, then create new database. assuming you really want to loose any and all data

[Anon]

ok thanks...what if the db was created by my hosting company which means i really can't delete it...what happens then? anything i can do??

[seansd]

use database;
show tables;

output this to a file. edit file to drop each table as needed i suppose. then run the script back against database

[Anon]

// get tables
$tables = mysql_list_tables('ringtone');
$tables_str = '';

// create string with all tables in it
while (list($table) = mysql_fetch_array($tables)) { $tables_str .= "$table,"; }

// remove last comma
$tables_str = substr($tables_str, 0, -1);

// delete tables
mysql_query("DROP TABLE IF EXISTS $tables_str;");