Explore your schema with SQL

When working with the InfluxDB Clustered SQL implementation a bucket is equivalent to a database, a measurement is equivalent to 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

View example output

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

View example output


Was this page helpful?

Thank you for your feedback!