Explore your schema with SQL

Use SQL to explore your data schema in your InfluxDB 3 Enterprise database.

List tables in a database

Use SHOW TABLES to list tables 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 table

Use the SHOW COLUMNS statement to view what columns are in a table. Use the IN clause to specify the table.

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 3 Enterprise and this documentation. To find support, use the following resources:

InfluxDB Discord Server (Preferred)
InfluxDB Community Slack
InfluxData Community
InfluxDB Subreddit

Customers with an annual or support contract can contact InfluxData Support. Customers using a trial license can email trial@influxdata.com for assistance.

Edit this page Submit docs issue Submit InfluxDB 3 Enterprise issue

Explore your schema with SQL

List tables in a database

List columns in a table

Support and feedback

The future of Flux

New in InfluxDB 3.4

Explore your schema with SQL

List tables in a database

List columns in a table

Support and feedback

What is your InfluxDB 3 Enterprise URL?

Default

Custom

Thank you for your feedback!

The future of Flux

New in InfluxDB 3.4