DROP [TEMPORARY] TABLE [IF EXISTS]
tbl_name] ... [RESTRICT | CASCADE]
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! If any of the tables named in the argument list do not exist, MySQL returns an error indicating by
name which nonexisting tables it was unable to drop, but it also drops all of the tables in the list that do
When a table is dropped, user privileges on the table are not automatically dropped. See Section
Note that for a partitioned table,
permanently removes the table definition, all of its partitions, and all of the data which was stored in those
partitions. It also removes the partitioning definition (
.par) file associated
with the dropped table.
IF EXISTS to prevent an error from occurring for tables that do not exist. A
NOTE is generated for each nonexistent table when using
EXISTS. See Section 126.96.36.199, "
CASCADE are permitted to make porting
easier. In MySQL 5.7, they do nothing.
DROP TABLE automatically commits the current active transaction, unless you
TEMPORARY keyword has the following effects:
The statement drops only
The statement does not end an ongoing transaction.
No access rights are checked. (A
TEMPORARY table is
visible only to the session that created it, so no check is necessary.)
TEMPORARY is a good way to ensure that you do not accidentally drop a