---
title: "Get Database Table Metadata"
method: GET
path: "/databases/{id}/tables/metadata"
tags: ["Databases"]
---

# Get Database Table Metadata

`GET /databases/{id}/tables/metadata`

Get the metadata of a table of a database

## Path parameters

- `id` string, objectid, required — ID of the database

## Query parameters

- `database` string — Name of the database
- `table` string, required — Name of the table

## Response `200`

OK

- ControllersResponseGithubEntityDatabaseTable
  - `data` EntityDatabaseTable — Updated table definition
    - `columns` EntityDatabaseColumn[]
      - `auto_increment` boolean
      - `children` EntityDatabaseColumn[]
      - `default` string
      - `extra` string
      - `hash` string
      - `key` string
      - `name` string
      - `not_null` boolean
      - `original_name` string
      - `primary` boolean
      - `status` string
      - `type` string
    - `indexes` EntityDatabaseIndex[]
      - `columns` EntityDatabaseIndexColumn[]
        - `name` string
        - `order` integer
      - `hash` string
      - `name` string
      - `original_name` string
      - `status` string
      - `type` string
      - `unique` boolean
    - `name` string
  - `error` string
  - `message` string
  - `status` string

## Other responses

- `400` — Bad Request
- `401` — Unauthorized
- `500` — Internal Server Error

## Changes

> 3 revisions in range; 1 could not be searched.

- **2025-03-03** `14e4eafea538` — 1 breaking, 3 warning, 2 info
  - the response's body type/format changed from `object`/`` to ``/`` for status `200`
  - removed the optional property `code` from the response with the `200` status
  - removed the optional property `data` from the response with the `200` status
  - removed the optional property `message` from the response with the `200` status
  - …2 more
- **2025-03-02** `526e5bdf6dee` — 1 breaking, 7 warning, 8 info
  - added the pattern `^[0-9a-fA-F]{24}$` to the `path` request parameter `id`
  - deleted the `query` request parameter `database`
  - deleted the `query` request parameter `table`
  - removed the optional property `data/columns` from the response with the `200` status
  - …12 more

[Change history](https://skmtc.dev/crawlab-team/apis/crawlab-api/changes/databases/:id/tables/metadata/get.md)

---

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