influxdb3 delete database
The influxdb3 delete database command deletes a database.
Usage
# 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
| Option | Description | |
|---|---|---|
-H | --host | Host URL of the running InfluxDB 3 Enterprise server (default is http://127.0.0.1:8181) |
--data-only | Delete only data while preserving schemas and all associated resources (tokens, triggers, caches, etc.). Default behavior deletes everything | |
--remove-tables | Used with --data-only to remove table resources (caches) while preserving database-level resources (tokens, triggers, processing engine configurations) | |
--hard-delete | When to hard delete data (never/now/default/timestamp). Default behavior is a soft delete that allows recovery | |
--token | Authentication token | |
--tls-ca | Path to a custom TLS certificate authority (for self-signed or internal certificates) | |
--tls-no-verify | Disable TLS certificate verification (Not recommended in production, useful for self-signed certificates) | |
-h | --help | Print help information |
--help-all | Print detailed help information |
Option environment variables
You can use the following environment variables to set command options:
| Environment Variable | Option |
|---|---|
INFLUXDB3_HOST_URL | --host |
INFLUXDB3_AUTH_TOKEN | --token |
INFLUXDB3_TLS_NO_VERIFY | --tls-no-verify |
Examples
In the examples below, replace the following:
DATABASE_NAME: Database nameAUTH_TOKEN: Authentication token
Delete a database
influxdb3 delete database DATABASE_NAMEDelete a database while specifying the token inline
influxdb3 delete database --token AUTH_TOKEN DATABASE_NAMEDelete 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.
influxdb3 delete database --data-only DATABASE_NAMEDelete 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.
influxdb3 delete database --data-only --remove-tables DATABASE_NAMEHard delete a database immediately
Permanently delete a database and all its data immediately without the ability to recover.
influxdb3 delete database --hard-delete now DATABASE_NAMEHard delete a database at a specific time
Schedule a database for permanent deletion at a specific timestamp.
influxdb3 delete database --hard-delete "2024-01-01T00:00:00Z" DATABASE_NAMEWas 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 3 Enterprise and this documentation. To find support, use the following resources:
Customers with an annual or support contract can contact InfluxData Support. Customers using a trial license can email trial@influxdata.com for assistance.