To delete a table from the database, run query in Mysql code editor
DROP TABLE table_name; Make sure you have selected the database from which you are going to delete a table.
Here, I am deleting a table “users” from the database named “jai_school“. So the first step will be of selecting a database by clicking on that particular database.
The SQL query to delete a table from a database
DROP TABLE users;
Now, you will see the query has done its work successfully.
The SQL query to delete multiple tables at once
DROP TABLE table1,table2;