influxdb3 delete table

The influxdb3 delete table command deletes a table from a database.

Usage

# Syntax
influxdb3 delete table [OPTIONS] --database <DATABASE_NAME> <TABLE_NAME>

Arguments

  • TABLE_NAME: The name of the table to delete.

Options

OptionDescription
-H--hostHost URL of the running InfluxDB 3 Core server (default is http://127.0.0.1:8181)
-d--database(Required) Name of the database to operate on
--hard-deleteWhen to hard delete data (never/now/default/timestamp). Default behavior is a soft delete that allows recovery
--token(Required) Authentication token
--tls-caPath to a custom TLS certificate authority (for self-signed or internal certificates)
--tls-no-verifyDisable TLS certificate verification (Not recommended in production, useful for self-signed certificates)
-h--helpPrint help information
--help-allPrint detailed help information

Option environment variables

You can use the following environment variables to set command options:

Environment VariableOption
INFLUXDB3_HOST_URL--host
INFLUXDB3_DATABASE_NAME--database
INFLUXDB3_AUTH_TOKEN--token
INFLUXDB3_TLS_NO_VERIFY--tls-no-verify

Examples

In the examples below, replace the following:

  • DATABASE_NAME: Database name
  • AUTH_TOKEN: Authentication token
  • TABLE_NAME: Name of the table to delete

Delete a table

influxdb3 delete table \
  --database 
DATABASE_NAME
 \
  --token 
AUTH_TOKEN
 \
  
TABLE_NAME

Hard delete a table immediately

Permanently delete a table and all its data immediately without the ability to recover.

influxdb3 delete table \
  --database 
DATABASE_NAME
 \
  --token 
AUTH_TOKEN
 \
  --hard-delete now \
  
TABLE_NAME

Was this page helpful?

Thank you for your feedback!