Manage tables
Manage tables in your InfluxDB Cloud Dedicated cluster. A table is a collection of related data stored in table format.
In previous versions of InfluxDB and in the context of InfluxQL, tables are known as “measurements.”
Create a table
Use the Admin UI, the influxctl table create command, or the Management HTTP API for InfluxDB Cloud Dedicated to create a new table in a specified database your InfluxDB cluster. Create a table with the same partitioning as the database or with a custom partition template.
CLI
influxctl table create <DATABASE_NAME> <TABLE_NAME>API
curl \
--location "https://console.influxdata.com/api/v0/accounts/ACCOUNT_ID/clusters/CLUSTER_ID/databases/DATABASE_NAME/tables/" \
--header "Authorization: Bearer MANAGEMENT_TOKEN" \
--json '{ "name": "TABLE_NAME" }'List tables
Use the Admin UI, the influxctl table list command, the SHOW TABLES SQL statement, or the SHOW MEASUREMENTS InfluxQL statement to list tables in a database.
CLI
influxctl table list <DATABASE_NAME>SQL
SHOW TABLESInfluxQL
SHOW MEASUREMENTSRename a table
Use the influxctl table rename command to rename a table in your InfluxDB Cloud Dedicated cluster.
CLI
influxctl table rename <DATABASE_NAME> <CURRENT_TABLE_NAME> <NEW_TABLE_NAME>Delete a table
Use the Admin UI or the influxctl table delete command to delete a table from a database in your InfluxDB Cloud Dedicated cluster.
influxctl table delete <DATABASE_NAME> <TABLE_NAME>Undelete a table
Use the influxctl table undelete command to restore a previously deleted table in your InfluxDB Cloud Dedicated cluster.
influxctl table undelete DATABASE_NAME TABLE_IDWas 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 Cloud Dedicated and this documentation. To find support, use the following resources:
Customers with an annual or support contract can contact InfluxData Support.