SQL Tutorial Home

How to Drop a Table in MySQL

To drop a table, just do:

drop table employee;

If the table doesn’t exist the drop will fail, then in order to avoid this potential error you can use a:

drop table if exists employee;