MySQL DROP Table

MySQL provides DROP statement to delete table. It deletes both table structure and data.
Once the data deleted, you can not recover them. So always be careful while delete the existing table.

Drop Table Syntax

DROP Table Tablename;

Here, the 'Tablename' is the name of table.

MySQL DROP Single Table

The given statement deletes the 'sports' table from database.

DROP TABLE sports;

MySQL DROP Multiple Tables

We can also delete more than one table using single DROP Table statement. The given statement deletes both 'tourist_city' and 'visiting_places' tables from database.

DROP TABLE tourist_city, visiting_places;