Description

You can execute the DROP TABLE statement to delete a table.

Synopsis

DROP TABLE [ IF EXISTS ] table_name [, ...] ;

Parameters

  1. You can execute DROP TABLE to delete multiple tables at a time.
  2. If you specify IF EXISTS, a success response is returned regardless of whether the table exists. If you do not specify IF EXISTS and the table does not exist, an error is thrown: ERROR: table "non_exist_table" does not exist.

Examples

DROP TABLE holo_test;