---
title: List tables
description: Use the influxctl table list command, the SHOW TABLES SQL statement, or the SHOW MEASUREMENTS InfluxQL statement to list tables in a database.
url: https://docs.influxdata.com/influxdb3/clustered/admin/tables/list/
estimated_tokens: 1888
product: InfluxDB Clustered
version: clustered
---

# List tables

Use the [`influxctl table list` command](/influxdb3/clustered/reference/cli/influxctl/table/list/), the [`SHOW TABLES` SQL statement](/influxdb3/clustered/query-data/sql/explore-schema/#list-measurements-in-a-database), or the [`SHOW MEASUREMENTS` InfluxQL statement](/influxdb3/clustered/query-data/influxql/explore-schema/#list-measurements-in-a-database) to list tables in a database.

With InfluxDB Clustered, tables and measurements are synonymous.

<!-- Tabbed content: Select one of the following options -->

**influxctl:**

Use the [`influxctl table list` command](/influxdb3/clustered/reference/cli/influxctl/table/list/) to list all tables in a database in your InfluxDBed.

```bash
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:

```sh
influxctl table list --format json DATABASE_NAME
```

**SQL & InfluxQL:**

## 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

```sql
SHOW TABLES
```

### InfluxQL

```sql
SHOW MEASUREMENTS
```

Provide the following with your command:

-   **Database token**: a [database token](/influxdb3/clustered/admin/tokens/#database-tokens) with read permissions on the queried database. Uses the `token` setting from the [`influxctl` connection profile](/influxdb3/clustered/reference/cli/influxctl/#configure-connection-profiles) or the `--token` command flag.
-   **Database name**: Name of the database to query. Uses the `database` setting from the [`influxctl` connection profile](/influxdb3/clustered/reference/cli/influxctl/#configure-connection-profiles) or the `--database` command flag.
-   **SQL query**: SQL query with the `SHOW TABLES` statement or InfluxQL query with the `SHOW MEASUREMENTS` statement.

##### SQL

```bash
influxctl query \
  --token DATABASE_TOKEN \
  --database DATABASE_NAME \
  "SHOW TABLES"
```

##### InfluxQL

```bash
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.

<!-- End tabbed content -->

#### Related

-   [influxctl table list](/influxdb3/clustered/reference/cli/influxctl/table/list/)
-   [Explore your schema with SQL](/influxdb3/clustered/query-data/sql/explore-schema/)
-   [Explore your schema with InfluxQL](/influxdb3/clustered/query-data/influxql/explore-schema/)