(mysql.info) drop-table
Info Catalog
(mysql.info) drop-index
(mysql.info) data-definition
(mysql.info) rename-table
13.1.8 `DROP TABLE' Syntax
--------------------------
DROP [TEMPORARY] TABLE [IF EXISTS]
TBL_NAME [, TBL_NAME] ...
[RESTRICT | CASCADE]
`DROP TABLE' removes one or more tables. You must have the `DROP'
privilege for each table. All table data and the table definition are
_removed_, so _be careful_ with this statement!
Use `IF EXISTS' to prevent an error from occurring for tables that do
not exist. A `NOTE' is generated for each non-existent table when using
`IF EXISTS'. See show-warnings.
`RESTRICT' and `CASCADE' are allowed to make porting easier. For the
moment, they do nothing.
* `DROP TABLE' automatically commits the current active
transaction, unless you use the `TEMPORARY' keyword.
The `TEMPORARY' keyword has the following effects:
* The statement drops only `TEMPORARY' tables.
* The statement does not end an ongoing transaction.
* No access rights are checked. (A `TEMPORARY' table is visible only
to the client that created it, so no check is necessary.)
Using `TEMPORARY' is a good way to ensure that you do not accidentally
drop a non-`TEMPORARY' table.
Info Catalog
(mysql.info) drop-index
(mysql.info) data-definition
(mysql.info) rename-table
automatically generated byinfo2html