Documentation

Explore your schema with SQL

When working with the InfluxDB Cloud Serverless 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 bucket

Use SHOW TABLES to list measurements in your InfluxDB bucket.

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!


New in InfluxDB 3.6

Key enhancements in InfluxDB 3.6 and the InfluxDB 3 Explorer 1.4.

See the Blog Post

InfluxDB 3.6 is now available for both Core and Enterprise. This release introduces the 1.4 update to InfluxDB 3 Explorer, featuring the beta launch of Ask AI, along with new capabilities for simple startup and expanded functionality in the Processing Engine.

For more information, check out:

InfluxDB Docker latest tag changing to InfluxDB 3 Core

On February 3, 2026, the latest tag for InfluxDB Docker images will point to InfluxDB 3 Core. To avoid unexpected upgrades, use specific version tags in your Docker deployments.

If using Docker to install and run InfluxDB, the latest tag will point to InfluxDB 3 Core. To avoid unexpected upgrades, use specific version tags in your Docker deployments. For example, if using Docker to run InfluxDB v2, replace the latest version tag with a specific version tag in your Docker pull command–for example:

docker pull influxdb:2

InfluxDB Cloud Serverless