Dropping primary key

To drop a primary key:

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. Select Drop Primary Key.
  9. Drop Primary Key dialog appears.
  10. Select either of the following to drop the primary key:

    • Restrict—In case where the referential constraints are dependent on this constraint, it cannot be dropped.

    • Cascade—In case where the referential constraints are dependent on this constraint, dependent referential constraints are dropped along with the specified constraint.

  11. Click Yes to drop the primary key or No to discard the changes.