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 and RESTRICT can occur before or after table_name, but not both.

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.
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;