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! 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 exist.

*Important*:

When a table is dropped, user privileges on the table are not
automatically dropped. See [HELP GRANT].

For a partitioned table, DROP TABLE permanently removes the table
definition, all of its partitions, and all of the data which was stored
in those partitions. It also removes partition definitions associated
with the dropped table.

*Note*:

Prior to MySQL 5.7.6, DROP TABLE removes partition definitions (.par)
files associated with the dropped table. As of MySQL 5.7.6, partition
definition (.par) files are no longer created. Instead, partition
definitions are stored in the internal data dictionary.

Use IF EXISTS to prevent an error from occurring for tables that do not
exist. A NOTE is generated for each nonexistent table when using IF
EXISTS. See [HELP SHOW WARNINGS].

IF EXISTS can be useful for dropping tables in unusual circumstances
under which there is an .frm file but no table managed by the storage
engine. (For example, if an abnormal server exit occurs after removal
of the table from the storage engine but before .frm file removal.)

RESTRICT and CASCADE are permitted to make porting easier. In MySQL
5.7, they do nothing.

*Note*:

DROP TABLE automatically commits the current active transaction, unless
you use the TEMPORARY keyword.

URL: http://dev.mysql.com/doc/refman/5.7/en/drop-table.html

