DROP TABLE
Removes a table.
Synopsis
DROP TABLE [IF EXISTS] <name> [, ...] [CASCADE | RESTRICT]
Description
DROP TABLE
removes tables from the database. Only its owner may drop a table. To empty a table of rows without removing the table definition, use TRUNCATE
.
DROP TABLE
always removes any indexes, rules, 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.
Parameters
Examples
Remove the table mytable
:
DROP TABLE mytable;
Compatibility
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 HAWQ extension.