MySQL

How to Delete Table in MySQL

In this tutorial, we are going to see how to delete a table from a MySQL database. It’s very easy to delete an existing MySQL table, but you should be careful when deleting an existing table, as lost data will not be recovered after deleting a table.
 
 

How to Delete Table in MySQL

Here is the SQL syntax for deleting a MySQL table.

DROP TABLE my_table;

Where “my_table” is the name of your MySQL table.
 

 
We can use the DROP TABLE statement to delete multiple tables. Here is an example:

DROP TABLE table1, table2, table3;
mcqMCQPractice competitive and technical Multiple Choice Questions and Answers (MCQs) with simple and logical explanations to prepare for tests and interviews.Read More

Leave a Reply

Your email address will not be published. Required fields are marked *