MySQL Drop Table
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. |
