---
title: "Update a table"
method: PATCH
path: "/datastore/{connection_id}/table/{id}"
tags: ["datastore", "table"]
---

# Update a table

`PATCH /datastore/{connection_id}/table/{id}`

## Path parameters

- `connection_id` string, required
- `id` string, required

## Query parameters

- `fields` string[]
- `raw` string

## Request body

- DatastoreTable
  - `id` string
  - `created_at` string, date-time
  - `updated_at` string, date-time
  - `name` string
  - `description` string
  - `database_id` string
  - `fields` DatastoreField[]
    - `id` string
    - `name` string, required
    - `type` 'TEXT' | 'NUMBER' | 'DATE' | 'BOOLEAN' | 'FILE' | 'TEXTAREA' | 'SINGLE_SELECT' | 'MULTIPLE_SELECT' | 'CURRENCY' | 'URL' | 'EMAIL' | 'PHONE' | 'LINKED_RECORD' | 'RELATION', required
    - `original_type` string, required
    - `is_required` boolean
    - `is_indexed` boolean
    - `is_primary_key` boolean
    - `is_unique` boolean
    - `is_nullable` boolean
    - `max_length` number
    - `precision` number
    - `scale` number
    - `default_value` PropertyDatastoreFieldDefaultValue
      - `string` string
      - `number` number
      - `boolean` boolean
      - `date` string
      - `selection` string[]
      - `is_null` boolean
    - `description` string
    - `raw` object
  - `relationships` DatastoreRelationship[]
    - `name` string, required
    - `field` string, required
    - `table_id` string, required
    - `type` 'ONE' | 'MANY', required
  - `web_url` string
  - `parent_id` string
  - `raw` object

## Response `200`

Successful

- DatastoreTable
  - `id` string
  - `created_at` string, date-time
  - `updated_at` string, date-time
  - `name` string
  - `description` string
  - `database_id` string
  - `fields` DatastoreField[]
    - `id` string
    - `name` string, required
    - `type` 'TEXT' | 'NUMBER' | 'DATE' | 'BOOLEAN' | 'FILE' | 'TEXTAREA' | 'SINGLE_SELECT' | 'MULTIPLE_SELECT' | 'CURRENCY' | 'URL' | 'EMAIL' | 'PHONE' | 'LINKED_RECORD' | 'RELATION', required
    - `original_type` string, required
    - `is_required` boolean
    - `is_indexed` boolean
    - `is_primary_key` boolean
    - `is_unique` boolean
    - `is_nullable` boolean
    - `max_length` number
    - `precision` number
    - `scale` number
    - `default_value` PropertyDatastoreFieldDefaultValue
      - `string` string
      - `number` number
      - `boolean` boolean
      - `date` string
      - `selection` string[]
      - `is_null` boolean
    - `description` string
    - `raw` object
  - `relationships` DatastoreRelationship[]
    - `name` string, required
    - `field` string, required
    - `table_id` string, required
    - `type` 'ONE' | 'MANY', required
  - `web_url` string
  - `parent_id` string
  - `raw` object

---

[API](https://skmtc.net/unified/apis/unified-to-api.md) · [All operations](https://skmtc.net/unified/apis/unified-to-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/unified/unified-to-api/versions/1f72720916e4/schema)