AttentionThis page documents an earlier version. Go to the latest (v2.1)version.
DROP TABLE command removes a table and all of its data from the database.
drop_table ::= DROP TABLE [ IF EXISTS ] qualified_name;
qualified_nameis a (possibly qualified) identifier.
- An error is raised if the specified
table_namedoes not exist.
- Associated objects to
table_namesuch as prepared statements will be eventually invalidated after the drop statement is completed.