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.
This is how you can use drop table command in MySQL:
Drop table table_name
For example:
|
1
|
Drop table tbl_emploee
|
The above command will remove the tbl_employee table from the database by using drop table statement.
Also see: MySQL create table | MySQL delete
Leave A Comment?