How To Delete Table in SQL (Single or Multiple)

Date Published: 05/03/2020 Published By: JaiSchool

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


Now, you will see the query has done its work successfully.

The SQL query to delete multiple tables at once

DROP TABLE table1,table2;

Publish A Comment

Leave a Reply

Your email address will not be published.