(mysql.info) drop-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