---
title: "Search for tables"
method: POST
path: "/tables/search"
tags: ["tables"]
---

# Search for tables

`POST /tables/search`

Based on table properties (currently only name) search for tables. This could be an internal or an external table.

## Headers

- `x-budibase-app-id` string, required

## Request body

- NameSearch
  - `name` string, required — The name to be used when searching - this will be used in a case insensitive starts with match.

## Response `200`

Returns the found tables, based on the search parameters.

- TableSearch
  - `data` object[], required
    - `name` string, required — The name of the table.
    - `primaryDisplay` string — The name of the column which should be used in relationship tags when relating to this table.
    - `schema` object, required
    - `_id` string, required — The ID of the table.

## Changes

- **2025-03-11** `a08581a55595` — 1 breaking, 1 info
  - added `subschema #1, subschema #2, subschema #3` to the `data/items/schema/additionalProperties/` response property `oneOf` list for the response status `200`
  - removed `subschema #1, subschema #2, subschema #3` from the `data/items/schema/additionalProperties/` response property `oneOf` list for the response status `200`
- **2024-10-30** `ac3872ebf1f7` — 1 info
  - removed the `ai` enum value from the `data/items/schema/additionalProperties/oneOf[subschema #2]/formulaType` response property for the response status `200`
- **2024-10-25** `8f1194cf2bd1` — 1 warning
  - added the new `ai` enum value to the `data/items/schema/additionalProperties/oneOf[subschema #2]/formulaType` response property for the response status `200`
- **2024-10-25** `99d87949ea70` — 1 info
  - removed the `ai` enum value from the `data/items/schema/additionalProperties/oneOf[subschema #2]/formulaType` response property for the response status `200`
- **2024-10-03** `330a066d6dd2` — 1 breaking, 1 info
  - added `subschema #2, subschema #3` to the `data/items/schema/additionalProperties/` response property `oneOf` list for the response status `200`
  - removed `subschema #2, subschema #3` from the `data/items/schema/additionalProperties/` response property `oneOf` list for the response status `200`

[Full history](https://skmtc.dev/budibase/apis/budibase-api/changes/tables/search/post.md)

---

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