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
  • Copy
  • Fill window

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
  • Copy
  • Fill window

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
  • Copy
  • Fill window

InfluxQL

SHOW MEASUREMENTS
  • Copy
  • Fill window

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"
  • Copy
  • Fill window
InfluxQL
influxctl query \
  --token 
DATABASE_TOKEN
\
--database
DATABASE_NAME
\
--language influxql \ "SHOW MEASUREMENTS"
  • Copy
  • Fill window

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!


The future of Flux

Flux is going into maintenance mode. You can continue using it as you currently are without any changes to your code.

Read more

New in InfluxDB 3.2

Key enhancements in InfluxDB 3.2 and the InfluxDB 3 Explorer UI is now generally available.

See the Blog Post

InfluxDB 3.2 is now available for both Core and Enterprise, bringing the general availability of InfluxDB 3 Explorer, a new UI that simplifies how you query, explore, and visualize data. On top of that, InfluxDB 3.2 includes a wide range of performance improvements, feature updates, and bug fixes including automated data retention and more.

For more information, check out: