DROP TABLE

The DROP TABLE statement removes the specified table.

Syntax

DROP TABLE [IF EXISTS] table-Name

table-Name

The name of the schema that you want to drop from your database.

Statement dependency system

Indexes and constraints , constraints (primary, unique, check and references from the table being dropped) and triggers on the table are silently dropped.

Dropping a table invalidates statements that depend on the table. (Invalidating a statement causes it to be recompiled upon the next execution. See Interaction with the dependency system.)

Example

splice> DROP TABLE Salaries;
0 rows inserted/updated/deleted

See Also