# Modifying the Table Schema

There are two ways to update a table [Schema Management](/products/customer-data-platform/data-workbench/databases/schema-management).

## Using Treasure Console

To update schema manually, navigate to:

1. Open Treasure Console.
2. Navigate to **Data** **Workbench** > **Databases.**
3. Select a database for which you want to modify the schema.
For example, test_db or:


![](/assets/image-20200827-003304.3bfad70b9a5d739de38252750160786a4865d5d93105e48c9f17c369c3e8a51b.4c190181.png)

1. Select a table.
For example:


![](/assets/image-20200827-004729.2046a096a96af4ded16a15ee90994eec1585f3bdde5e021ea351792ec6af1965.4c190181.png)

1. Select **Add Column**.


![](/assets/image-20200827-004821.c1caa0943e4d8f021ecc7231c679d762a879a26cdc87f5f1ffec3230fb3f3ed4.4c190181.png)

1. Specify the table metadata details.
For example:


![](/assets/image-20200827-010304.b851e4ff0c83e13372fe38d4a611479966c15456ce47ed960375a64262029044.4c190181.png)

1. Select **Save**.
2. Optionally, to continue customizing the schema and metadata, select **Edit Schema**.


![](/assets/image-20200827-010428.c9cf9d76c91134fb2ca71d84d3ea0e2af4ab18a441fb6c1aaa40a9818e4f6541.4c190181.png)

1. Optionally, to continue customizing the schema and metadata, select **Add Column.**
2. Optionally, to delete a column from your table, select **Edit Schema** and select the **x** to the far right of the page.
3. Optionally, select **… > Table Settings**.


![](/assets/image-20200827-011034.eb96d55c9fc2ebdd96a8285fed23a404223bfd458b1dc5b24316a10002ca8be5.4c190181.png)

1. Optionally, make selections on **Edit Settings**.
2. Optionally, select **Confirm**.
3. Select **Save** when your schema modification is complete.


## Using Treasure CLI Tool

Alternatively, you can use the td schema:set command

* where `<column_name>` consists of lowercase alphabets, numbers, and "_" only
* where `<type>` can be one of the following: `int`, `long`, `double`, `float`, `string`, `array<T>`



```bash
$ td schema:set <database> <table> <column_name>:<type>...
```

For this example, the schema would be added as follows:


```bash
td schema:set testdb www_access action:string labels:'array<string>' user:int
```

You can find available data types on [TD Native Data Types](/products/customer-data-platform/data-workbench/databases/td-native-data-types).