If you use the IF EXISTS clause along with the DROP TABLE statement as shown below, the specified table will be dropped and if a table with the given name, doesn’t exist the query will be ignored. If you try to drop a table that doesn’t exist error will be generated as shown below −ĮRROR 1051 (42S02): Unknown table 'mo' Once a table is dropped, if you verify the list of the tables as shown below you can see its name is missing − You can delete three of the above created tables using the DROP TABLE statement as shown below − If you verify the list of tables you can observe the created ones in the list as follows − This is mostly uses to suppress error messages in the database schema creation scripts. Mysql> CREATE TABLE TestTable4(value VARCHAR(10)) In MySQL you can use IF EXISTS clause in the DROP TABLE statement. Mysql> CREATE TABLE TestTable3(value VARCHAR(10)) Mysql> CREATE TABLE TestTable2(value VARCHAR(10)) Syntax: DROP TEMPORARY TABLE IF EXISTS tablename, tablename. The command removes all the data and table definition from the database. The user who is using the DROP command, must have DROP privilege for each table (s) he wants to drop. Mysql> CREATE TABLE TestTable1(value VARCHAR(10)) In MySQL, DROP TABLE command removes one or more tables from an existing database. Suppose we have created tables as shown below −

Where, table_name is the name of the table you need to delete.

Syntaxįollowing is the syntax of the DROP TABLE statement − First, right-click on the one you want to delete. If it exists, you drop the table, if it doesnt exist you can skip the DROP TABLE. That statement drops the table if it exists but will not throw an error if it. Once you delete a table all records, triggers, constraints and permission of the table are lost. If you can access the Workbench, it is easy to delete any table. Just put DROP TABLE IF EXISTS tablename before your CREATE TABLE statement. You can drop/delete an existing table using the DROP TABLE Statement.

Drop table if exists mysql