> ## Documentation Index
> Fetch the complete documentation index at: https://docs.zangtable.com/llms.txt
> Use this file to discover all available pages before exploring further.

# PATCH /projects/{project}/column/{table}

> Applies multiple column patches.

Applies multiple column patches.

## Endpoint details

<ParamField header="Authorization" type="string" required>
  Bearer `pat_...` (Project API Token). Keep this token on your backend/server.
</ParamField>

<ParamField path="project" type="string" required>
  Project slug. This acts as the Project ID in API paths.
</ParamField>

<ParamField path="table" type="string" required>
  Table name inside the project.
</ParamField>

<ResponseField name="ok" type="boolean" required>
  `true` for a successful response and `false` for an error response.
</ResponseField>

<ResponseField name="data" type="object | null">
  Endpoint-specific response data when `ok` is `true`; `null` on errors.
</ResponseField>

<ResponseField name="error" type="object | null">
  Error code and message when `ok` is `false`; `null` on success.
</ResponseField>

<ResponseField name="request_id" type="string" required>
  Request identifier you can use when troubleshooting a specific API call.
</ResponseField>

## Authentication

Project API Token.

## Parameters

Path: `table` required. Body: `columns` required array of objects. Each object must include `column_name` or an id/name understood by the patch handler plus patch fields accepted by single-column patch.

## Request examples

Basic request:

```bash theme={null}
curl -X PATCH "$BASE_URL/projects/{project}/column/{table}" \
  -H 'Authorization: Bearer pat_PROJECT_TOKEN' \
  -H 'Content-Type: application/json' \
  --data '{"columns":[{"column_name":"email","is_unique":true}]}'
```

Full request:

```bash theme={null}
curl -X PATCH "$BASE_URL/projects/{project}/column/{table}" \
  -H 'Authorization: Bearer pat_PROJECT_TOKEN' \
  -H 'Content-Type: application/json' \
  -H 'X-Operation-Key: edit-profile-email' \
  -H 'X-Operation-Run-Id: oprun_client_20260602_001' \
  --data '{"columns":[{"column_name":"email","new_column_name":"email_address","column_type":"TEXT","is_nullable":false,"default_value":null,"is_unique":true}]}'
```

## Response examples

Success:

```json theme={null}
{
  "ok": true,
  "data": {
    "updated_count": 1
  },
  "error": null,
  "request_id": "req_20260602T012345_123456Z_abc123def456",
  "operation_key": "edit-profile-email",
  "operation_run_id": "oprun_20260602T012300_000000Z_a1b2c3d4e5f6",
  "operation_grouping_status": "accepted_provided_run",
  "meta": {
    "generated_at": "2026-06-02T01:23:45Z"
  }
}
```

Error or alternate response:

```json theme={null}
{
  "ok": false,
  "data": null,
  "error": {
    "code": "invalid_columns",
    "message": "columns must be an array of column patch objects."
  },
  "request_id": "req_20260602T012345_123456Z_abc123def456",
  "meta": {
    "generated_at": "2026-06-02T01:23:45Z"
  }
}
```
