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
add_retention_policy()
Add a policy to drop older chunks
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
Data retention
Timescale Cloud API reference for data retention. Includes SQL functions for adding and removing data retention policies that run on a schedule that you define