DROP TABLE

Synopsis

Use the DROP TABLE statement to remove one or more tables (with all of their data) from the database.

Syntax

• Grammar
• Diagram

drop_table ::= DROP TABLE [ IF EXISTS ] table_name [ , ... ]

drop_table

Semantics

drop_table

if_exists

Under normal operation, an error is raised if the table does not exist. Adding IF EXISTS will quietly ignore any non-existent tables specified.

table_name

Specify the name of the table to be dropped. Objects associated with the table, such as prepared statements, will be eventually invalidated after the DROP TABLE statement is completed.

See also

• CREATE TABLE
• INSERT
• SELECT