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
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
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.
Parent topic: SQL Commands