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.

From the release of NuoDB 3.4, the CASCADE 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

schema

Optional. The name of the schema that owns the table to be dropped. If schema is not provided, the table must be owned by the current schema.

table_name

Name (optionally schema-qualified) of an existing table to drop.

IF EXISTS

If the table does not exist and you specify IF EXISTS, NuoDB does not generate an error. If not specified and the table does not exist, an error is generated.

CASCADE

The CASCADE keyword is provided only for syntax compatibility and is ignored by NuoDB.

RESTRICT

The RESTRICT keyword is provided only for syntax compatibility and is ignored by NuoDB.

== Example

USE HOCKEY
DROP TABLE hockey_fan;
 can't find table "HOCKEY_FAN"
DROP TABLE IF EXISTS hockey_fan;

CREATE TABLE hockey_fan (id     INTEGER GENERATED ALWAYS AS IDENTITY,
                         name   STRING );

DROP TABLE hockey_fan;