DROP TABLE

Description

You can drop an existing table by the DROP statement. Multiple tables can be dropped by a single DROP statement. All rows of table are also dropped. If you use it together with the IF EXISTS statement, you can prevent errors from occurring and specify multiple tables in one statement.

Syntax

DROP [ TABLE | CLASS ] [ IF EXISTS ] <table_specification_comma_list>

 

<table_specification_comma_list> ::=

<single_table_spec> | ( <table_specification_comma_list> )

 

<single_table_spec> ::=

|[ ONLY ] table_name

| ALL table_name [ ( EXCEPT table_name, ... ) ]

Example

DROP TABLE history ;

 

CREATE TABLE t (i INT);

 

-- DROP TABLE IF EXISTS

DROP TABLE IF EXISTS history, t;

 2 command(s) successfully processed.

 SELECT * FROM t;  In line 1, column 10, ERROR: Unknown class "t".