---
title: "List tables"
method: GET
path: "/tables"
tags: ["Tables"]
---

# List tables

`GET /tables`

Gets the list of all available tables under the parent catalog and schema.
There is no guarantee of a specific ordering of the elements in the array.

## Query parameters

- `catalog_name` string, required
- `schema_name` string, required
- `max_results` integer
- `page_token` string

## Response `200`

The tables list was successfully retrieved.

- ListTablesResponse
  - `tables` TableInfo[] — An array of table information objects.
    - `name` string — Name of table, relative to parent schema.
    - `catalog_name` string — Name of parent catalog.
    - `schema_name` string — Name of parent schema relative to its parent catalog.
    - `table_type` 'MANAGED' | 'EXTERNAL'
    - `data_source_format` 'DELTA' | 'CSV' | 'JSON' | 'AVRO' | 'PARQUET' | 'ORC' | 'TEXT' — Data source format
    - `columns` ColumnInfo[] — The array of __ColumnInfo__ definitions of the table's columns.
      - `name` string — Name of Column.
      - `type_text` string — Full data type specification as SQL/catalogString text.
      - `type_json` string — Full data type specification, JSON-serialized.
      - `type_name` 'BOOLEAN' | 'BYTE' | 'SHORT' | 'INT' | 'LONG' | 'FLOAT' | 'DOUBLE' | 'DATE' | 'TIMESTAMP' | 'TIMESTAMP_NTZ' | 'STRING' | 'BINARY' | 'DECIMAL' | 'INTERVAL' | 'ARRAY' | 'STRUCT' | 'MAP' | 'CHAR' | 'NULL' | 'USER_DEFINED_TYPE' | 'TABLE_TYPE' — Name of type (INT, STRUCT, MAP, etc.).
      - `type_precision` integer — Digits of precision; required for DecimalTypes.
      - `type_scale` integer — Digits to right of decimal; Required for DecimalTypes.
      - `type_interval_type` string — Format of IntervalType.
      - `position` integer — Ordinal position of column (starting at position 0).
      - `comment` string — User-provided free-form text description.
      - `nullable` boolean — Whether field may be Null.
      - `partition_index` integer — Partition index for column.
    - `storage_location` string — Storage root URL for table (for **MANAGED**, **EXTERNAL** tables)
    - `comment` string — User-provided free-form text description.
    - `properties` SecurablePropertiesMap — A map of key-value properties attached to the securable.
    - `created_at` integer — Time at which this table was created, in epoch milliseconds.
    - `updated_at` integer — Time at which this table was last modified, in epoch milliseconds.
    - `table_id` string — Unique identifier for the table.
  - `next_page_token` string — Opaque token to retrieve the next page of results. Absent if there are no more pages. __page_token__ should be set to this value for the next request (for the next page of results).

---

[API](https://skmtc.dev/unitycatalog/apis/unity-catalog-api.md) · [All operations](https://skmtc.dev/unitycatalog/apis/unity-catalog-api/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/unitycatalog/unity-catalog-api/revisions/afb7536b3c70/schema)