Documentation

List tables

Use the influxctl table list command, the SHOW TABLES SQL statement, or the SHOW MEASUREMENTS InfluxQL statement to list tables in a database.

With InfluxDB Clustered, tables and measurements are synonymous.

Use the influxctl table list command to list all tables in a database in your InfluxDBed.

influxctl table list 
DATABASE_NAME

Replace the following:

  • DATABASE_NAME: Name of the database containing the tables to list

Output formats

The influxctl table list command supports the following output formats:

  • table (default): Human-readable table format
  • json: JSON format for programmatic use

Use the --format flag to specify the output format:

influxctl table list --format json 
DATABASE_NAME

List tables with the influxctl query command

To list tables using SQL or InfluxQL, use the influxctl query command to pass the appropriate statement.

SQL

SHOW TABLES

InfluxQL

SHOW MEASUREMENTS

Provide the following with your command:

  • Database token: a database token with read permissions on the queried database. Uses the token setting from the influxctl connection profile or the --token command flag.
  • Database name: Name of the database to query. Uses the database setting from the influxctl connection profile or the --database command flag.
  • SQL query: SQL query with the SHOW TABLES statement or InfluxQL query with the SHOW MEASUREMENTS statement.
SQL
influxctl query \
  --token 
DATABASE_TOKEN
\
--database
DATABASE_NAME
\
"SHOW TABLES"
InfluxQL
influxctl query \
  --token 
DATABASE_TOKEN
\
--database
DATABASE_NAME
\
--language influxql \ "SHOW MEASUREMENTS"

Replace the following:

  • DATABASE_TOKEN: Database token with read access to the queried database
  • DATABASE_NAME: Name of the database to query

The influxctl query command only supports SQL queries; not InfluxQL. To use InfluxQL, query InfluxDB through the API using InfluxQL request parameters.


Was this page helpful?

Thank you for your feedback!


New in InfluxDB 3.5

Key enhancements in InfluxDB 3.5 and the InfluxDB 3 Explorer 1.3.

See the Blog Post

InfluxDB 3.5 is now available for both Core and Enterprise, introducing custom plugin repository support, enhanced operational visibility with queryable CLI parameters and manual node management, stronger security controls, and general performance improvements.

InfluxDB 3 Explorer 1.3 brings powerful new capabilities including Dashboards (beta) for saving and organizing your favorite queries, and cache querying for instant access to Last Value and Distinct Value caches—making Explorer a more comprehensive workspace for time series monitoring and analysis.

For more information, check out:

InfluxDB Docker latest tag changing to InfluxDB 3 Core

On November 3, 2025, 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