Is there any way to delete a table from a database? All i know how to do is delete and re-add an entire database.
Thanks in advance.
i'll assume we're still talking about tables here.
drop table table_name;
http://www.mysql.com/doc/D/R/DROP_TABLE.html
the syntax for an entire database would be similiar.
drop database database_name;
http://www.mysql.com/doc/D/R/DROP_DATABASE.html
just use DROP for table rather than database:
if(! mysql_query("DROP TABLE yourtable")) die ("Unable to drop table");
else echo "Successfully dropped table";
QK