DROP TABLE statement 

A DROP TABLE statement deletes a base table (see Table).

Syntax

<drop table statement> ::= DROP TABLE <table name> [<cascade option>]

table name, cascade option

Explanation

The table name must be the name of an existing base table. The current user must be the owner of the base table.

All of the metadata and rows in the base table, as well as view definitions, indexes, privileges, synonyms, and referential CONSTRAINT definitions derived from them are deleted.

CASCADE option RESTRICT: the DROP TABLE statement will fail if view tables or synonyms are based on the specified table.

No CASCADE option specified: the CASCADE value is accepted.

If all of the data that is linked to this base table by means of a referential constraint definition with a DELETE rule, are processed according to the specified DELETE rule, a DELETE statement must first be executed for this base table and then the DROP TABLE statement.