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

Option environment variables

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

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

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.

influxdb3 delete table \
  --database 
DATABASE_NAME
 \
  --token 
AUTH_TOKEN
 \
  --data-only \
  
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