Vertica Analytics Platform Version 9.2.x Documentation
Removes a table and its projections. When you run
DROP TABLE, the change is auto-committed.
DROP TABLE [ IF EXISTS ][ [database.]schema.]table[,…] [ CASCADE ]
Specifies not to report an error if one or more of the tables to drop does not exist. This clause is useful in SQL scripts where you want to drop a table if it exists before recreating it.
Specifies a schema, by default
If you specify a database, it must be the current database.
The table to drop.
Specifies to drop all projections for this table before the table is dropped.
This option is not valid for external tables.
- Table owner with USAGE privilege on table's schema
- Schema owner
- 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.
See Dropping Tables in the Administrator's Guide.
Was this topic helpful?