---
title: "Get All"
method: GET
path: "/tables/"
tags: ["TABLES"]
---

# Get All

`GET /tables/`

Gets all tables.
- datasources: search parameter
- databases: search parameter
- schemas: search parameter
- contract_ids: search parameter
- keyword: general search parameter for table name or column name

## Query parameters

- `page` integer — Page number
- `size` integer — Page size
- `datasource_type` string, nullable
- `datasources` string[], nullable
- `databases` string[], nullable
- `schemas` string[], nullable
- `contract_ids` integer[], nullable
- `tags` string[], nullable
- `keyword` string, nullable
- `navigationSource` string, nullable

## Response `200`

Successful Response

- PageTableFetchResponse
  - `items` TableFetchResponse[], required
    - `id` integer, required
    - `name` string, required
    - `datasource_type` string, required
    - `scope` string[], required
    - `columns` ColumnSchemaMetadata[], required
      - `table_schema_id` integer, required
      - `column_description` string, nullable
      - `created_on` string, date-time, nullable
      - `name` string, required
      - `datatype` string, required
      - `tags` ColumnTag[], nullable
        - `name` string, required
        - `description` string, nullable
      - `description_frozen` boolean, nullable
      - `last_modified_by` integer, nullable
    - `purpose` string, nullable
    - `purpose_frozen` boolean, nullable
    - `contracts` AppSchemasTablesContractFetchResponse[], required
      - `id` integer, required
      - `name` string, required
      - `status` string, required
      - `level` string, required
    - `total_violations` integer, nullable
    - `last_violation_timestamp` string, nullable
    - `last_modified_by` integer, nullable
    - `tags` ColumnTag[], nullable
      - `name` string, required
      - `description` string, nullable
    - `matches` MatchResult
      - `table_name` boolean, required
      - `column_names` integer, required
      - `table_purpose_match` boolean, required
      - `column_description_matches` integer, required
  - `total` integer, nullable, required
  - `page` integer, nullable, required
  - `size` integer, nullable, required
  - `pages` integer, nullable

## Other responses

- `400` — Not supported for public user
- `403` — Not supported for public user
- `422` — Validation Error

---

[API](https://skmtc.net/myaltimate/apis/fastapi.md) · [All operations](https://skmtc.net/myaltimate/apis/fastapi/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/myaltimate/fastapi/versions/aab3fe5c9f05/schema)