Removes a table.
DROP TABLE [IF EXISTS] <name> [, ...] [CASCADE | RESTRICT]
DROP TABLE
removes tables from the database. Only the table owner, the schema owner, and superuser can drop a table. To empty a table of rows without removing the table definition, use DELETE
or TRUNCATE
.
DROP TABLE
always removes any indexes, rules, triggers, and constraints that exist for the target table. However, to drop a table that is referenced by a view, CASCADE
must be specified. CASCADE
will remove a dependent view entirely.
Remove the table mytable
:
DROP TABLE mytable;
DROP TABLE
is fully conforming with the SQL standard, except that the standard only allows one table to be dropped per command. Also, the IF EXISTS
option is a Greenplum Database extension.
CREATE TABLE, ALTER TABLE, TRUNCATE
Parent topic: SQL Commands