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

# GET /tables

`GET /tables`

Gets an array of all tables for the current metastore under the parent catalog and schema.

 The caller must be a metastore admin or an owner of (or have the SELECT privilege on) the table.
 For the latter case, the caller must also be the owner or have the USE_CATALOG privilege on the
 parent catalog and the USE_SCHEMA privilege on the parent schema. There is no guarantee of a
 specific ordering of the elements in the array.

## Query parameters

- `schemaName` string
- `catalogName` string
- `maxResults` integer
- `pageToken` string
- `includeDeltaMetadata` boolean
- `omitColumns` boolean
- `omitProperties` boolean
- `omitUsername` boolean
- `includeBrowse` boolean
- `includeManifestCapabilities` boolean

## Response `200`

OK

- ListTablesResponse
  - `tables` TableInfo[] — The tables returned.
    - `name` string — Name of table, relative to parent schema.
    - `schemaName` string — Name of parent schema.
    - `catalogName` string — Name of parent catalog.
    - `tableType` integer
    - `dataSourceFormat` integer — Data source format of the table.
    - `columns` ColumnInfo[] — The array of ColumnInfo definitions of the table's columns.
      - `name` string — Name of the column
      - `typeText` string — Full data type specification as SQL/catalogString text.
      - `typeJson` string — Full data type specification, JSON-serialized.
      - `typeName` integer — Data type name.
      - `typePrecision` integer — Digits of precision; required for DecimalTypes.
      - `typeScale` integer — Digits to right of decimal; Required for DecimalTypes.
      - `typeIntervalType` 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.
      - `partitionIndex` integer — Partition index for column.
      - `columnId` string — a unique id for the column
    - `storageLocation` string — Storage root URL for table (for MANAGED, EXTERNAL tables)
    - `owner` string — Username of current owner of table.
    - `comment` string — User-provided free-form text description.
    - `properties` object — A map of key-value properties attached to the securable.
    - `storageCredentialName` string — Name of the storage credential, when a storage credential is configured for use with this table.
    - `fullName` string — Full name of table, in form of catalog_name.schema_name.table_name.
    - `createdAt` string — Time at which this table was created, in epoch milliseconds.
    - `createdBy` string — Username of table creator.
    - `updatedAt` string — Time at which this table was last updated, in epoch milliseconds.
    - `updatedBy` string — Username of user who last modified table.
    - `deletedAt` string — Time at which this table was deleted, in epoch milliseconds. Field is omitted if table is not deleted.
    - `tableId` string — Unique identifier for the table.
  - `nextPageToken` string — The next_page_token value to include in the next List request.

## Other responses

- `default` — Default error response

---

[API](https://skmtc.net/delta-incubator/apis/delta-sharing-api.md) · [All operations](https://skmtc.net/delta-incubator/apis/delta-sharing-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/delta-incubator/delta-sharing-api/versions/a47a0389fffc/schema)