Vertica Analytics Platform Version 9.2.x Documentation
Removing Table Data
Vertica provides several ways to remove data from a table:
|Drop a table||Permanently remove a table and its definition, optionally remove associated views and projections.|
|Delete table rows||
Mark rows with delete vectors and store them so data can be rolled back to a previous epoch. The data must be purged to reclaim disk space.
|Truncate table data||
Remove all storage and history associated with a table. The table structure is preserved for future use.
|Purge data||Permanently remove historical data from physical storage and free disk space for reuse.|
Remove one more partitions from a table. Each partition contains a related subset of data in the table. Dropping partitioned data is efficient, and provides query performance benefits.
In This Section
Was this topic helpful?