Explore your schema with SQL
When working with the InfluxDB SQL implementation, a bucket is equivalent to a database, a measurement is structured as a table, and time, fields, and tags are structured as columns.
List measurements in a database
Use SHOW TABLES to list measurements in your InfluxDB database.
SHOW TABLES
List columns in a measurement
Use the SHOW COLUMNS statement to view what columns are in a measurement.
Use the IN clause to specify the measurement.
SHOW COLUMNS IN home
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 and this documentation. To find support, use the following resources:
Customers with an annual or support contract can contact InfluxData Support.