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.
DROP [ TABLE | CLASS | VIEW | VCLASS ] < table_specification_comma_list>
< table_specification> ::=
< single_table_spec> | ( < single_table_spec_comma_list> )
< single_table_spec> ::=
|[ ONLY ] table_name
| ALL table_name [ ( EXCEPT table_name, ... ) ]
- table_name : Specifies the name of the table to be dropped. You can delete multiple tables simultaneously by separating them with commas.
- If a super class name is specified after the ONLY keyword, only the super class, not the subclasses inheriting from it, is deleted. If a super class name is specified after the ALL keyword, the super classes as well as the subclasses inheriting from it are all deleted. You can specify the list of subclasses not to be deleted after the EXCEPT keyword.
- If subclasses that inherit from the super class specified after the ALL keyword are specified after the EXCEPT keyword, they are not deleted.
The following is an example of dropping the history table.
DROP TABLE history