5.4.3. DROP TABLE
Used for
deleting a table
Available in
DSQL, ESQL
Syntax
DROP TABLE tablename
Parameter | Description |
---|---|
tablename | Name (identifier) of the table |
The DROP TABLE
statement deletes an existing table. If the table has dependencies, the DROP TABLE
statement will fail with an execution error.
When a table is dropped, all triggers for its events and indexes built for its fields will be deleted as well.
Only the table owner and administrators have the authority to use DROP TABLE
.
Example
Deleting the COUNTRY
table.
DROP TABLE COUNTRY;
See also