DROP TABLE
DROP TABLE;delete table;
Removes one or more tables and their projections. When you run DROP TABLE
, the change is auto-committed.
Syntax
DROP TABLE [ IF EXISTS ]
[ [database.]schema.]table[,…] [ CASCADE ]
Parameters
IF EXISTS
|
Specifies not to report an error if one or more of the tables to drop does not exist. Use this clause in SQL scripts to avoid errors on dropping non-existent objects before attempting to create them. |
[database.]schema
|
Specifies a schema, by default myschema.thisDbObject If you specify a database, it must be the current database. |
table
|
The table to drop. |
CASCADE
|
Specifies to drop all projections of the target tables. This option is not valid for external tables. |
Privileges
Non-superuser:
- Table: owner, or DROP privilege
- Table schema: owner, or USAGE privilege
Requirements
- Do not cancel an executing
DROP TABLE
. Doing so can leave the database in an inconsistent state. - Check that the target table is not in use, either directly or indirectly—for example, in a view.
- If you drop and restore a table that is referenced by a view, the new table must have the same name and column definitions.
Examples
See Dropping Tables