Explore your schema with SQL

When working with the InfluxDB SQL implementation, 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

View example output

table_catalog	table_schema	table_name	table_type
public	iox	home	BASE TABLE
public	iox	noaa	BASE TABLE
public	system	queries	BASE TABLE
public	information_schema	tables	VIEW
public	information_schema	views	VIEW
public	information_schema	columns	VIEW
public	information_schema	df_settings	VIEW

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

table_catalog	table_schema	table_name	column_name	data_type	is_nullable
public	iox	home	co	Int64	YES
public	iox	home	hum	Float64	YES
public	iox	home	room	Dictionary(Int32, Utf8)	YES
public	iox	home	temp	Float64	YES
public	iox	home	time	Timestamp(Nanosecond, None)	NO

query sql

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:

InfluxData Community
InfluxDB Community Slack

Customers with an annual or support contract can contact InfluxData Support.

Edit this page Submit docs issue Submit InfluxDB issue

Explore your schema with SQL

List measurements in a database

List columns in a measurement

Support and feedback

What is your InfluxDB Cloud Dedicated cluster URL?

Enter cluster URL

Thank you for your feedback!

The future of Flux