DROP TABLE
Attention
This page documents an earlier version. Go to the latest (v2.3) version.Synopsis
Use the DROP TABLE
statement to remove one or more tables (with all of their data) from the database.
Syntax
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.