Mysql Drop tables examples

It is easy to drop an existing MySQL table, but you need to be very careful while deleting any existing table because the data lost will not be recovered after deleting a table.

Syntax:

the syntax for the DROP TABLE statement in MySQL is:

DROP TABLE table_name ;

Drop Table Examples : 

DROP table Country;

Table if Exists DROP statement:

DROP TABLE IF EXISTS Country;

Drop Temperary table:

DROP TEMPORARY TABLE IF EXISTS Country;

Drop Multiple Tables:

DROP TABLE IF EXISTS Country,State;