# Modifying or Customizing the Table Schema

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

## Using TD Console

To update schema manually, navigate to:

1. Open TD 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)
4. 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 TD 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 see the following articles for more query syntax:

* [Writing Hive Queries](https://api-docs.treasuredata.com/en/tools/hive/quickstart/)
* [Writing Trino Queries](https://api-docs.treasuredata.com/en/tools/presto/quickstart/)


## Treasure Data, Presto, and Hive Schema Relation

| **Treasure Data** | **Presto** | **Hive** |
|  --- | --- | --- |
| int | bigint | smallint |
| int | bigint | int |
| long | bigint | bigint |
| double | double | decimal |
| float | double | float |
| double | double | double |
| Convert to string or int | boolean | boolean |
| string | varchar | string or varchar |
| string or Convert to long | date | string |
| string or Convert to long | timestamp | timestamp |


You can refer to the open-source documentation as well:

* [Presto](https://prestodb.io/docs/current/language/types.md)
* [Hive](https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL)