---
title: List tables
description: Use the influxdb3 CLI or HTTP API to list tables in a specified database in InfluxDB 3 Enterprise. Use SQL SHOW TABLES or InfluxQL SHOW MEASUREMENTS statements.
url: https://docs.influxdata.com/influxdb3/enterprise/admin/tables/list/
estimated_tokens: 2713
product: InfluxDB 3 Enterprise
version: enterprise
---

# List tables

Use the [`influxdb3 query` command](/influxdb3/enterprise/reference/cli/influxdb3/query/) or the [HTTP API](/influxdb3/enterprise/api/v3/) to list tables in a specified database in InfluxDB 3 Enterprise.

With InfluxDB 3 Enterprise, tables and measurements are synonymous. This guide shows how to retrieve a list of all tables (measurements) in a database.

-   [List tables using the influxdb3 CLI](#list-tables-using-the-influxdb3-cli)
-   [List tables using the HTTP API](#list-tables-using-the-http-api)

## List tables using the influxdb3 CLI

Use the `influxdb3 query` command with the `SHOW TABLES` SQL statement:

```sh
influxdb3 query \
  --database DATABASE_NAME \
  --token AUTH_TOKEN \
  "SHOW TABLES"
```

Replace the following:

-   `DATABASE_NAME`: the name of the database to list tables from
-   `AUTH_TOKEN`: your [admin token](/influxdb3/enterprise/admin/tokens/)

### Example output

```
+---------------+---------------+------------+------------+
| table_catalog | table_schema  | table_name | table_type |
+---------------+---------------+------------+------------+
| public        | iox           | home       | BASE TABLE |
| public        | iox           | sensors    | BASE TABLE |
+---------------+---------------+------------+------------+
```

### Alternative: List tables using InfluxQL

You can also use InfluxQL syntax to list measurements (tables):

```sh
influxdb3 query \
  --language influxql \
  --database DATABASE_NAME \
  --token AUTH_TOKEN \
  "SHOW MEASUREMENTS"
```

## List tables using the HTTP API

To list tables using the HTTP API, send a `GET` request to the `/api/v3/query_sql` endpoint with a `SHOW TABLES` query:

GET localhost:8181/api/v3/query\_sql

Include the following in your request:

-   **Query parameters**:
    -   `db`: Database name
    -   `q`: The SQL query (`SHOW TABLES`)
    -   `format`: Response format (optional, defaults to `json`)
-   **Headers**:
    -   `Authorization: Bearer` with your authentication token

```bash
curl --get "localhost:8181/api/v3/query_sql" \
  --header "Authorization: Bearer AUTH_TOKEN" \
  --data-urlencode "db=DATABASE_NAME" \
  --data-urlencode "q=SHOW TABLES" \
  --data-urlencode "format=json"
```

Replace the following:

-   `DATABASE_NAME`: the name of the database to list tables from
-   `AUTH_TOKEN`: your [admin token](/influxdb3/enterprise/admin/tokens/)

### Example response

```json
{
  "results": [
    {
      "series": [
        {
          "name": "tables",
          "columns": ["table_catalog", "table_schema", "table_name", "table_type"],
          "values": [
            ["public", "iox", "home", "BASE TABLE"],
            ["public", "iox", "sensors", "BASE TABLE"]
          ]
        }
      ]
    }
  ]
}
```

### Get response in CSV format

To get the response in CSV format, set the `format` parameter to `csv`:

```bash
curl --get "localhost:8181/api/v3/query_sql" \
  --header "Authorization: Bearer AUTH_TOKEN" \
  --data-urlencode "db=DATABASE_NAME" \
  --data-urlencode "q=SHOW TABLES" \
  --data-urlencode "format=csv"
```

#### Related

-   [influxdb3 query](/influxdb3/enterprise/reference/cli/influxdb3/query/)
-   [Query API](/influxdb3/enterprise/api/query-data/#operation/GetExecuteQuerySQL)