8.18. DROP TABLE

Synopsis

  1. DROP TABLE  [ IF EXISTS ] table_name

Description

Drops an existing table.

The optional IF EXISTS clause causes the error to be suppressed ifthe table does not exist.

Examples

Drop the table orders_by_date:

  1. DROP TABLE orders_by_date

Drop the table orders_by_date if it exists:

  1. DROP TABLE IF EXISTS orders_by_date

See Also

ALTER TABLE, CREATE TABLE