Use TimescaleHypertables

Drop a hypertable

Drop a hypertable using a standard PostgreSQL DROP TABLE command:

DROP TABLE <TABLE_NAME>;

All data chunks belonging to the hypertable are deleted.

Keywords

hypertablesdelete

Found an issue on this page?Report an issue or Edit this page in GitHub.

PreviousImprove query performanceNextTroubleshoot hypertables

Related Content

Dropping data
Drop a view or raw data from a continuous aggregate or its underlying hypertable in Timescale Cloud
Delete data
Delete data with DELETE or by dropping chunks from a hypertable in your Timescale Cloud service using SQL
Manually drop chunks
If data retention policies don't meet your ad hoc needs, you can manually drop chunks from your hypertables based on time value. Learn how to do it in Timescale Cloud
Create a data retention policy
Create a data retention policy to automatically drop historical data from your hypertables when it reaches a certain age. Timescale Cloud enables you to save on storage while speeding up your queries
Compression
With data compression, you can achieve a significant improvement in the performance of your analytical queries. Learn how to enable and benefit from data compression in Timescale Cloud
Hypertables
Hypertables are PostgreSQL tables with special features that power real-time analytics on time-series and event data. Learn to use hypertabes in your Timescale Cloud service