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;