Delete a table
Use the Admin UI or the influxctl table delete command
to delete a table from a database in your InfluxDBed cluster.
Deleting a table is irreversible. Once a table is deleted, all data stored in that table is permanently removed and cannot be recovered.
Provide the following arguments:
- Database name: Name of the database that contains the table to delete
- Table name: Name of the table to delete
influxctl table delete DATABASE_NAME TABLE_NAMEReplace the following:
DATABASE_NAME: Name of the database that contains the table to deleteTABLE_NAME: Name of the table to delete
When prompted, enter y to confirm the deletion.
Wait before reusing a deleted table name
After deleting a table, wait a few minutes before attempting to create a new table with the same name to ensure the deletion process has fully completed.
InfluxDB Clustered creates tables implicitly using table names specified in line protocol written to the databases. To prevent the deleted table from being immediately recreated by incoming write requests, pause all write requests to the table before deleting it.
Was this page helpful?
Thank you for your feedback!
Support and feedback
Thank you for being part of our community! We welcome and encourage your feedback and bug reports for InfluxDB Clustered and this documentation. To find support, use the following resources:
Customers with an annual or support contract can contact InfluxData Support.