delete-table

How To Delete Table in SQL (Single or Multiple)

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;

Leave a Comment