Altering a table

NOTE:

To alter a table, you must be logged on as one of the following:

  • The owner of the table.

  • The owner of the schema that contains the table.

  • The SUPER user.

To alter a table:

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 from the context menu.
  8. The following are the Alter Table options:

    • Attributes—This menu item is used to alter the table attributes.

    • Add Column(s)—This menu item is used to add new columns to the table.

    • Add Primary Key—This menu item is used to add a primary key.

    • Add Unique Constraint—This menu item is used to add an unique constraint.

    • Add Check Constraint—This menu item is used to add a check constraint.

    • Add Foreign Key—This menu item is used to add a foreign key.

    • Alter Identity Column—This menu item is used to modify the identity column.

    • Drop Foreign Key—This menu item is used to drop a foreign key.

    • Drop Unique Constraint—This menu item is used to drop a unique constraint.

    • Drop Check Constraint—This menu item is used to drop a check constraint.

    • Drop Primary Key—This menu item is used to drop primary key of the table.