ContextQMD
Back to Influxdb

Syntax

content/shared/influxdb3-cli/delete/table.md

latest4.9 KB
Original Source

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

Usage

<!--pytest.mark.skip-->
bash
# Syntax
influxdb3 delete table [OPTIONS] --database <DATABASE_NAME> <TABLE_NAME>

Arguments

  • TABLE_NAME: The name of the table to delete.

Options

<!--docs:exclude --table-name: internal variable, use positional <TABLE_NAME> -->

{{% hide-in "enterprise" %}}

OptionDescription
-H--hostHost URL of the running {{< product-name >}} server (default is http://127.0.0.1:8181)
-d--database({{< req >}}) 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({{< req >}}) 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
{{% /hide-in %}}

{{% show-in "enterprise" %}}

OptionDescription
-H--hostHost URL of the running {{< product-name >}} server (default is http://127.0.0.1:8181)
-d--database({{< req >}}) Name of the database to operate on
--data-onlyDelete only data while preserving the table schema and all associated resources (caches, etc.). Default behavior deletes everything
--hard-deleteWhen to hard delete data (never/now/default/timestamp). Default behavior is a soft delete that allows recovery
--token({{< req >}}) 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
{{% /show-in %}}

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:

  • {{% code-placeholder-key %}}DATABASE_NAME{{% /code-placeholder-key %}}: Database name
  • {{% code-placeholder-key %}}AUTH_TOKEN{{% /code-placeholder-key %}}: Authentication token
  • {{% code-placeholder-key %}}TABLE_NAME{{% /code-placeholder-key %}}: Name of the table to delete

Delete a table

<!--pytest.mark.skip-->
bash
influxdb3 delete table \
  --database DATABASE_NAME \
  --token AUTH_TOKEN \
  TABLE_NAME

{{% show-in "enterprise" %}}

Delete table data only (preserve schema and resources)

Delete all data from a table while preserving:

  • Table schema (column definitions)
  • Last value caches (LVC) and distinct value caches (DVC) associated with the table

This is useful when you want to clear old data and re-write new data to the same schema without recreating the table structure.

<!--pytest.mark.skip-->
bash
influxdb3 delete table \
  --database DATABASE_NAME \
  --token AUTH_TOKEN \
  --data-only \
  TABLE_NAME

{{% /show-in %}}

Hard delete a table immediately

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

<!--pytest.mark.skip-->
bash
influxdb3 delete table \
  --database DATABASE_NAME \
  --token AUTH_TOKEN \
  --hard-delete now \
  TABLE_NAME