The DROP syntax is as follows:
DROP DATABASE [IF EXISTS] database_name DROP TABLE [IF EXISTS] table_name [, table_name,...] [RESTRICT | CASCADE] DROP INDEX index_name ON table_name
DROP DATABASE removes the database and all its tables.
DROP TABLE removes the specified table.
DROP INDEX removes the specified index.
MySQL returns an error if the database doesn't exist, unless the IF EXISTS clause is used.
DROP TABLE automatically commits active transactions.
RESTRICT and CASCADE are not currently implemented.