Creating a Column

Add a column to an existing table.

1. In the Perspective Resources view, select the server on which the table resides, then click the drop-down arrow next to the server name and select Administration Console.
2. In the left pane of the Administration Console, expand ASE Servers > Schema Objects > Tables, then choose one of the following:
   • User Tables
   • Proxy Tables
3. Select the table for the new column.
4. Select Properties.
5. From the Table Properties window, select Columns > New.
   You see the Add Column wizard.
6. In the Name window, enter the name of the column.
7. In the SQL Editor window, enter the SQL statements for the new column and related objects.
8. (Optional) Click Summary to verify your selected options.