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

# AddColumnOptions

> Add allowed labels to a select, select_number, or tag column. A select column's options are explicit schema: SQL accepts exactly the labels the column carries and rejects everything else, so a value that does not exist yet has to be added here before it can be written.  Use this when the user names a new status, stage, or category, or when a write they asked for was refused for an unknown option. Labels the column already has are ignored, so it is safe to send the whole set. A select_number column's labels must be numbers.  This is add-only — options are never renamed or removed here, because both would change what rows already holding them mean. Requires edit access. The response is the column after the change, with the labels SQL now accepts, plus the database's refreshed schema. If `database` is null, the option change was still saved; heed warning and DescribeDatabase before continuing. Do not treat a failed follow-up read as a rejected mutation.

# AddColumnOptions

Add allowed labels to a select, select\_number, or tag column. A select column's options are explicit schema: SQL accepts exactly the labels the column carries and rejects everything else, so a value that does not exist yet has to be added here before it can be written.

Use this when the user names a new status, stage, or category, or when a write they asked for was refused for an unknown option. Labels the column already has are ignored, so it is safe to send the whole set. A select\_number column's labels must be numbers.

This is add-only — options are never renamed or removed here, because both would change what rows already holding them mean. Requires edit access. The response is the column after the change, with the labels SQL now accepts, plus the database's refreshed schema. If `database` is null, the option change was still saved; heed warning and DescribeDatabase before continuing. Do not treat a failed follow-up read as a rejected mutation.

## Parameters

| Parameter | Type | Required | Description |
| - | - | - | - |
| `databaseId` | string | Yes | Id of the database the column belongs to, from ListDatabases. |
| `tableId` | string | Yes | Id of the table the column belongs to, from DescribeDatabase. It must belong to databaseId. |
| `columnId` | string | Yes | Id of the column to add options to, from DescribeDatabase. It must be a select, select\_number, or tag column. |
| `labels` | string\[] | Yes | The labels to add, as SQL will write them — e.g. \["Waitlisted"]. Labels the column already has are ignored. |


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