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

In MySQL 3.22 or later, you can use the keywords IF EXISTS to prevent
an error from occurring for tables that do not exist. As of MySQL 4.1,
a NOTE is generated for each non-existent table when using IF EXISTS.
See [HELP SHOW WARNINGS].

RESTRICT and CASCADE are allowed to make porting easier. In MySQL 4.1
and earlier, they do nothing.

Note: DROP TABLE automatically commits the current active transaction,
unless you are using MySQL 4.1 or higher and the TEMPORARY keyword.
