MySQL drop table command

How to drop table in MySQL

MySQL provides drop table command that is used to drop or delete a database table permanently.

Note that, the Drop table command not only removes the table data but also the table structure including any primary key, foreign key, unique constraint etc.

Following is the syntax and example of using the drop table command.

MySQL drop table syntax

This is how you can use drop table command in MySQL:

Drop table table_name

For example:

The above command will remove the tbl_employee table from the database by using drop table statement.

Also see: MySQL create table | MySQL delete

Was this article helpful?

Related Articles

Leave A Comment?