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
Here, the 'Tablename' is the name of table.
DROP Table Tablename;
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;