Syntax

• DROP TABLE table_name;
• DROP TABLE IF EXISTS table_name; – to avoid pesky error in automated script
• DROP TABLE t1, t2, t3; – DROP multiple tables
• DROP TEMPORARY TABLE t; – DROP a table from CREATE TEMPORARY TABLE …

Parameters

| Parameters | Details | | —— | —— | | TEMPORARY | Optional. It specifies that only temporary tables should be dropped by the DROP TABLE statement. IF EXISTS |Optional. If specified, the DROP TABLE statement will not raise an error if one of the tables does not exist.