ContextQMD
Back to Influxdb

Syntax

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

latest6.3 KB
Original Source

The influxdb3 delete database command deletes a database.

Usage

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

Arguments

  • DATABASE_NAME: The name of the database to delete. Valid database names are alphanumeric and start with a letter or number. Dashes (-) and underscores (_) are allowed.

    Environment variable: INFLUXDB3_DATABASE_NAME

Options

<!--docs:exclude --database-name: internal variable, use positional <DATABASE_NAME> -->

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

OptionDescription
-H--hostHost URL of the running {{< product-name >}} server (default is http://127.0.0.1:8181)
--hard-deleteWhen to hard delete data (never/now/default/timestamp). Default behavior is a soft delete that allows recovery
--tokenAuthentication 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)
--data-onlyDelete only data while preserving schemas and all associated resources (tokens, triggers, caches, etc.). Default behavior deletes everything
--remove-tablesUsed with --data-only to remove table resources (caches) while preserving database-level resources (tokens, triggers, processing engine configurations)
--hard-deleteWhen to hard delete data (never/now/default/timestamp). Default behavior is a soft delete that allows recovery
--tokenAuthentication 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_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

Delete a database

<!--pytest.mark.skip-->
bash
influxdb3 delete database DATABASE_NAME

Delete a database while specifying the token inline

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

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

Delete database data only (preserve schema and resources)

Delete all data from a database while preserving:

  • Database schema (tables and columns)
  • Authentication tokens
  • Processing engine configurations and triggers
  • Last value caches (LVC) and distinct value caches (DVC)

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

<!--pytest.mark.skip-->
bash
influxdb3 delete database --data-only DATABASE_NAME

Delete database data and tables (preserve database resources)

Delete all data and table resources (caches) while preserving database-level resources:

  • Authentication tokens
  • Processing engine triggers
  • Processing engine configurations

This is useful when you want to start fresh with a new schema but keep existing authentication and trigger configurations.

<!--pytest.mark.skip-->
bash
influxdb3 delete database --data-only --remove-tables DATABASE_NAME

{{% /show-in %}}

Hard delete a database immediately

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

<!--pytest.mark.skip-->
bash
influxdb3 delete database --hard-delete now DATABASE_NAME

Hard delete a database at a specific time

Schedule a database for permanent deletion at a specific timestamp.

<!--pytest.mark.skip-->
bash
influxdb3 delete database --hard-delete "2024-01-01T00:00:00Z" DATABASE_NAME