Adding columns

To add a column:

Procedure

  1. Log on to the MXDM.
  2. In the Navigation tree pane, click Database.

    MXDM displays a list of available systems in My Systems.

  3. Expand a selected system in the navigation tree.

    List of catalogs for the selected system appears.

  4. Click and expand the contents of a Catalog.

    The list of schemas appears.

  5. Expand a schema in the left pane.

    The Tables folder appears.

  6. Expand the Tables folder and select a table in the left pane.
  7. Right-click the table and select Alter Table and then Add Column(s) from the context menu.

    Add Column(s) dialog appears.

  8. Click Add to launch the Specify Column dialog.

    Specify Column dialog appears where you can enter the relevant details in the fields of the dialog to create a new column for the table.

  9. Click Edit to launch the Specify Column dialog with populated attribute values for the selected column.

    Specify Column dialog appears where you can modify the existing values for the selected column.

  10. Click OK to apply the changes made in the Add Column(s) dialog, or click Cancel to discard the changes.