GNU Info

(mysql.info)DROP TABLE

---

Next: CREATE INDEX Prev: RENAME TABLE Up: Data Definition

---

Enter node , (file) or (file)node

`DROP TABLE' Syntax
-------------------

     DROP TABLE [IF EXISTS] tbl_name [, tbl_name,...] [RESTRICT | CASCADE]

`DROP TABLE' removes one or more tables. All table data and the table
definition are _removed_, so *be careful* with this command!

In MySQL Version 3.22 or later, you can use the keywords `IF EXISTS' to
prevent an error from occurring for tables that don't exist.

`RESTRICT' and `CASCADE' are allowed to make porting easier.  For the
moment they don't do anything.

*NOTE*: `DROP TABLE' is not transaction-safe and will automatically
commit any active transactions.