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;
DROP Table

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;
DROP Multiple Tables

Read more articles

General Knowledge

Learn Popular Language