Vertica Analytics Platform Version 9.2.x Documentation
DROP TABLE;delete table;
Removes one or more tables and their 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. Use this clause in SQL scripts to avoid errors on dropping non-existent objects before attempting to create them.
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 of the target tables.
This option is not valid for external tables.
- 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
Was this topic helpful?