MySQL – DROP Table
In MySQL, an existing table is deleted using the Drop Table statement. This statement removes the entire data of a table, along with its entire structure or definition, from the database permanently. It is critical that you be extremely careful when deleting a table, as we are unable to recover the data once it has been removed.
In MySQL, the following syntax is used to remove the table:
DROP TABLE table_name;
DROP TABLE employees;
DROP TABLE if exists employees;
Using the IF EXISTS clause with the DROP TABLE statement results in the following error message from MySQL: