Delete a table

Use the influxctl table delete command to delete a table from a database in your InfluxDBed cluster.

Wait before writing to a new table with the same name

After deleting a table from your InfluxDBed cluster, you can reuse the name to create a new table, but wait two to three minutes after deleting the previous table before writing to the new table to allow write caches to clear.

Deleted tables may be able to be restored

Deleted tables may be able to be restored within the configurable “hard-delete” grace period.

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_NAME

Replace the following:

  • DATABASE_NAME: Name of the database that contains the table to delete
  • TABLE_NAME: Name of the table to delete

When prompted, enter y to confirm the deletion.

Pause writes before deleting a table

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!