---
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: 2123
product: InfluxDB Cloud Dedicated
version: cloud-dedicated
---

# List tables

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.

With InfluxDB Cloud Dedicated, tables and measurements are synonymous.

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

**Admin UI:**

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).

![InfluxDB Cloud Dedicated Admin UI tables list](/img/influxdb3/cloud-dedicated-admin-ui-tables.png)

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.

**influxctl:**

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

**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**: [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

<!-- End tabbed content -->

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