Drop Table
suggest changeSyntax
- 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.
Found a mistake? Have a question or improvement idea?
Let me know.
Table Of Contents