DROP TABLE

DROP TABLE — remove a table

Syntax

DROP TABLE 
    [IF EXISTS] [CASCADE | RESTRICT] [schema.]table_name
DROP TABLE 
    [schema.]table_name [IF EXISTS] [CASCADE | RESTRICT]

Description

Use the DROP TABLE statement to remove the table and all its data.
Only its owner may remove a table. A table may be emptied of rows, but not removed, by using DELETE. You can also use TRUNCATE. (See DELETE, TRUNCATE.)
DROP TABLE always removes any indexes, triggers, and constraints that exist for the target table.
IF EXISTS, CASCADE and RESTRICT can occur before or after table_name, but not both.

Note: From the release of NuoDB 3.4, the CASCASE option is deprecated. The optional CASCADE parameter no longer drops all tables in a table hierarchy list. Nor does it drop all tables containing foreign keys pointing to the dropped table. For more information on features deprecated in this release, see Deprecated Features.

Parameters