MySQL Drop Table Statement literally drops the existing table from a database. I mean, MySQL drop table removes or deletes all the records in a given one along with the structure or definition.
The basic syntax behind this MySQL Drop Table Statement is
DROP TABLE TableName; Or DROP TABLE Schema_name.TableName;
For this demonstration, we are using the below

MySQL Drop Table Example
In this example, we are going to delete the empdetails that we have shown above.
NOTE: You should be careful while using this statement. You might lose your data, and you have to recreate the same MySQL table on your own.
DROP TABLE sqltest.empdetails;

Let me try to run the select statement against the table that we deleted before. You can see the response, Error Code: 1146

If you try to remove the one that doesn’t exist, it throws an error. For instance, let me delete the already removed one, i.e., empdetails.

From the above screenshot, you can see the error. To avoid this, we can use the IF EXISTS parameter.
DROP TABLE IF EXISTS sqltest.empdetails;

As you see, the above code is giving you a warning with a meaningful message.
Using Command Prompt
You can use the MySQL Drop Table statement from the command prompt or Terminal to eliminate it. Here, we are deleting the employee details and then trying to select records from it. As you can see, it was throwing an error.
DROP TABLE sqltest.employeedetails; SELECT * FROM sqltest.employeedetails;

Using Workbench
If you can access the MySQL Workbench, it was easy to delete any table. First, right-click on the one you want to delete. i.e., the dim customer. Next, select the Drop.. option

It opens the following pop up window.

If you want, you can review the query generated by selecting the Review SQL, or else, click on the Drop Now button.

Let us see the list of them under the sqltest schema.

MySQL Drop Multiple Tables
To delete more than one, you have to separate those names using a comma. This example deletes multiple tables, such as dim currency and department3.
DROP TABLE IF EXISTS sqltest.dimcurrency, sqltest.department3;
We successfully deleted the two.
