DROP TABLE

Synopsis

Use the DROP TABLE statement to remove a table and all of its data from the database.

Syntax

• Grammar
• Diagram

drop_table ::= DROP TABLE [ IF EXISTS ] table_name

Semantics

drop_table

table_name

Specify the name of the table to be dropped. If the table does not exist, an error is raised. 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