---
title: List tables
description: Use the Admin UI, 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/cloud-dedicated/admin/tables/list/
estimated_tokens: 938
publisher: InfluxData
canonical: https://docs.influxdata.com/influxdb3/cloud-dedicated/admin/tables/list/
date: '2026-05-15T15:46:14-06:00'
lastmod: '2026-05-15T15:46:14-06:00'
---

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

> [!Note]
> With InfluxDB Cloud Dedicated, tables and measurements are synonymous.

[Admin UI](#admin-ui)[influxctl](#influxctl)[SQL & InfluxQL](#sql--influxql)

The InfluxDB Cloud Dedicated administrative UI includes a portal for managing
tables. You can view the list of tables associated with a database and
their details.

Access the InfluxDB Cloud Dedicated Admin UI at [console.influxdata.com](https://console.influxdata.com).
If you don’t have login credentials, [contact InfluxData support](https://support.influxdata.com).

<img src="/img/influxdb3/cloud-dedicated-admin-ui-tables.png" alt="InfluxDB Cloud Dedicated Admin UI tables list" width="1722">

Use the **Tables** page to manage tables within databases:

* Select a database from the dropdown to view its tables.
* View table IDs and sizes.
* See database size summary.
* Create new tables.
* Access detailed table schema information.

You can **Search** for tables by name or ID to filter the list and use the
sort button and column headers to sort the list.

Use the [`influxctl table list` command](/influxdb3/cloud-dedicated/reference/cli/influxctl/table/list/)to list all tables in a database in your InfluxDB Cloud Dedicated cluster.

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

## 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**: [Database token](/influxdb3/cloud-dedicated/admin/tokens/#database-tokens)with read permissions on the queried database. Uses the `token` setting from
  the [`influxctl` connection profile](/influxdb3/cloud-dedicated/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/cloud-dedicated/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

#### Related

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