Skip to content
TimescaleDB - Timeseries database for PostgreSQL
  • Timescale.com
  • Try for free
Get started
Use Timescale
Services
Clouds and regions
Resources
PostgreSQL extensions
Connecting to Timescale
Hypertables
About hypertables
Create hypertables
Change hypertable chunk intervals
Alter hypertables
Create unique indexes on hypertables
Drop hypertables
Troubleshoot hypertables
Distributed hypertables
Time buckets
Write data
Ingest data from other sources
Migration
Query data
Configuration
Schema management
Compression
Data retention
Continuous aggregates
High availability and replication
User-defined actions
Alerting
VPC
Backup and restore
Billing and account management
Metrics and logging
User Management
Upgrades
Hyperfunctions
Data tiering
Security
Timescale limitations
Troubleshoot Timescale
Tutorials
Code quick starts
API Reference
Other deployment options
About Timescale
Find a docs page
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

hypertablesdeleteTimescaleManaged Service for TimescaleDBself-hosted TimescaleDB

Found an issue on this page?

Report an issue!
PreviousCreate unique indexes on hypertablesNextTroubleshoot hypertables

Related Content

Dropping data
Drop raw data from a continuous aggregate or its underlying hypertable
Delete data
How to delete data from Timescale
Manually drop chunks
Manually drop chunks from your hypertable based on time value
Create a data retention policy
Create a data retention policy to automatially drop historical data
Compression
Learn how compression works in Timescale
Hypertables
Hypertables are PostgreSQL tables with special features that make it easy to handle time-series data