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].

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

