Explore your schema with SQL

When working with the InfluxDB Cloud Dedicated SQL implementation

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!