Manage tables
Tables are synonymous with measurements in InfluxDB 3 Core. They are typically created automatically when you write line protocol data, but you can also manually create them to define custom schemas or apply settings. before writing data.
Create a table
Use the influxdb3 create table
command or the HTTP API to create a new table in a specified database in InfluxDB 3 Core. Provide the database name, table name, and tag columns.
# CLI
influxdb3 create table \
--tags tag1,tag2,tag3 \
--database <DATABASE_NAME> \
--token <AUTH_TOKEN> \
<TABLE_NAME>
# HTTP API
curl -X POST "http://localhost:8181/api/v3/configure/table" \
--header "Authorization: Bearer <AUTH_TOKEN>" \
--header "Content-Type: application/json" \
--data '{"db": "<DATABASE_NAME>", "table": "<TABLE_NAME>", "tags": ["tag1", "tag2", "tag3"]}'
List tables
Use the influxdb3 query
command or the HTTP API to list tables in a specified database in InfluxDB 3 Core. Use SQL SHOW TABLES or InfluxQL SHOW MEASUREMENTS statements.
# CLI
influxdb3 query \
--database <DATABASE_NAME> \
--token <AUTH_TOKEN> \
"SHOW TABLES"
# HTTP API
curl --get "http://localhost:8181/api/v3/query_sql" \
--header "Authorization: Bearer <AUTH_TOKEN>" \
--data-urlencode "db=<DATABASE_NAME>" \
--data-urlencode "q=SHOW TABLES"
Delete a table
Use the influxdb3 delete table
command or the HTTP API to delete a table from a specified database in InfluxDB 3 Core. Supports both soft delete and hard delete operations.
# CLI
influxdb3 delete table \
--database <DATABASE_NAME> \
--token <AUTH_TOKEN> \
<TABLE_NAME>
# HTTP API
curl -X DELETE "http://localhost:8181/api/v3/configure/table?db=<DATABASE_NAME>&table=<TABLE_NAME>" \
--header "Authorization: Bearer <AUTH_TOKEN>"
Was 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 Core and this documentation. To find support, use the following resources:
Customers with an annual or support contract can contact InfluxData Support.