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

# Delete column

> Permanently delete a column and its values. Rate limit: 10 write requests per minute per workspace, one write at a time per workspace, plus 60 requests per minute per API key. 100 column changes per UTC day per workspace.

> [!WARNING]
>
> Deleting a column is permanent. Its values are removed from every row and cannot be restored, unlike deleted tables and rows.

Only `text`, `email`, `phone`, `url`, `number` and `json` columns can be deleted through the API. Other types return `400` with `code: "read_only_column"`.

The column disappears from responses immediately, and its values are cleared in the background. Until that finishes, other writes to the table return `409` with `code: "table_operation_conflict"`; retry after a few seconds.

> [!NOTE]
>
> Paid plans only. No credits are charged. Limits: 10 write requests per minute per workspace, one write at a time per workspace, plus 60 requests per minute per API key. 100 column changes per UTC day per workspace. See the [Tables API overview](https://docs.airscale.io/api-reference/tables/overview.md) for every limit.

## Authentication

Send `Authorization: Bearer $AIRSCALE_API_KEY`. The key determines the workspace. See [Authentication](https://docs.airscale.io/api-reference/authentication.md).

## Parameters

| Name | Location | Required | Description |
| - | - | - | - |
| `table_id` | path | Yes | Table ID returned by Create table or List tables. |
| `column_id` | path | Yes | Column ID from the table's columns. |

## Request example

Replace path variables with IDs returned by the API. Column UUIDs in the example body must belong to your table.

```bash theme={"theme":{"light":"github-light","dark":"github-dark"}}
curl --request DELETE "https://api.airscale.io/v1/tables/$TABLE_ID/columns/$COLUMN_ID" \
  --header "Authorization: Bearer $AIRSCALE_API_KEY"
```

## Response

### 200

The column was deleted.

```json theme={"theme":{"light":"github-light","dark":"github-dark"}}
{
  "deleted": true,
  "id": "bc629d4d-cc75-4cee-b10a-851203d82fac"
}
```

## Errors

| Status | Meaning |
| - | - |
| 400 | The column is read-only (enrichment, formula, date or deliverability), or an ID is invalid. |
| 401 | Missing or invalid API key. |
| 403 | The workspace does not have an active paid plan. |
| 404 | Table or column not found in this workspace, or deleted. |
| 409 | Another table operation is running. |
| 429 | A rate limit, the one-write-at-a-time rule or a daily limit was reached. Wait for Retry-After before retrying. |
| 502 | The service could not be reached. Retry with backoff. |
| 503 | The service is at capacity or temporarily unavailable. Retry after Retry-After. |
| 504 | The request timed out after 30 seconds. A write may still have been applied; check the result before retrying it. |

See [limits, retries and error codes](https://docs.airscale.io/api-reference/tables/overview.md#limits) for shared behavior.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.