Add a column to an existing table.
- 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.
- In the left pane of the Administration Console, expand , then choose one of the following:
- Select the table for the new column.
- Select Properties.
- From the Table Properties window, select .
You see the Add Column wizard.
- In the Name window, enter the name of the column.
- In the SQL Editor window, enter the SQL statements for the new column and related objects.
- (Optional) Click Summary to verify your selected options.