Adding Columns to Table

Option Add Column allows you to manually add a column to a table and is available on the Table Details page.

Perform the following steps to add a column to a table.

1. On the left sidebar, click TABLES to open the Tables page.

2. On the Tables page, click the name of the table to which a column will be added. This will open its Table Details page.

3. On the Table Details page, under the Columns tab, click Add Column.

4. In the New Column dialog, specify the name of the column.

5. Select the data type for the column from the drop-down list.

6. Optionally, select whether the column will be nullable, a key column or a distribution key column.

7. Optionally, add an attribute to a column.

   1. Click +Add Attribute.
   2. Select an attribute from the drop-down list.
   3. Specify or select a value next to the added attribute.

8. Click Save to add the column to the table.