Adding a Column to a Table

To add a column to a table
  1. In the Object Explorer, select the table and choose Edit from the popup menu.
    The new Table Editor document opens in the Document pane. The Columns page of the Table Editor document is displayed by default.
  2. Right-click the grid row where you want to insert the column.
    The Column popup menu appears.
  3. Select Insert Column.
    A new grid row is added. If you want to add the column to the end, choose Add Column from popup menu.
  4. Modify the new column properties in the Columns page.
    To modify setting in the Special column, double-click the grid row to display the Columns Properties dialog box. You can also choose Properties from the popup menu.
  5. Click OK to apply the column properties to the table.
  6. Choose Table->Execute to save the table in the database.