Adding columns
To add a column:
Procedure
- Log on to the MXDM.
-
In the Navigation tree pane, click
Database.
MXDM displays a list of available systems in My Systems.
-
Expand a selected system in the navigation tree.
List of catalogs for the selected system appears.
-
Click and expand the contents of a Catalog.
The list of schemas appears.
-
Expand a schema in the left pane.
The Tables folder appears.
- Expand the Tables folder and select a table in the left pane.
-
Right-click the table and select
Alter Table and then
Add Column(s) from the context menu.
Add Column(s) dialog appears.
-
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.
-
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.
- Click OK to apply the changes made in the Add Column(s) dialog, or click Cancel to discard the changes.