Hudzilla.org - the homepage of Paul Hudson

9.3.5 Deleting tables

This is NOT the latest copy of this book; click here for the latest version.

If you ever want to permanently delete tables from your database one at a time, the command to use is "DROP table ;", so "DROP usertable;" will delete the usertable table we just created, "DROP AnotherTable;" will delete the AnotherTable table, etc.

If you want to delete all tables in a database at once, it is easiest to use the "DROP DATABASE some_database " functionality already discussed - when a database is deleted, all tables it holds are also deleted.

<< 9.3.4 Making table changes		9.3.6 Inserting data >>
Table of Contents

Want to see this stuff in print? PHP in a Nutshell takes the core topics covered here, adds in thousands of edits from the editorial team and myself, and combines them to make an unbeatable reference for PHP programmers at all levels.

My latest book has hundreds more tips on how to use PHP, Apache, and MySQL, plus Perl, Python, shell scripts, performance tuning, and more!

A PHP User - 29 Aug 2008

THE syntax for delete table should be,
DROP TABLE sometable;

Add comment
Please note that by posting a comment here you are committing it to the public domain. This is important so that others can make use of your code themselves, and also so that I can incorporate helpful notes directly into the main text. Comments are limited to 2000 characters in length.

If you are reporting an error in the content, please tell me directly.