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 TABLES
InfluxQL
SHOW MEASUREMENTS
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>
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 Cloud Dedicated and this documentation. To find support, use the following resources:
Customers with an annual or support contract can contact InfluxData Support.