Dropping foreign key

To drop a foreign 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.
    NOTE:

    Drop Foreign key menu is enabled only if the table contains a foreign key.

  8. Select Drop Foreign Key.

    Drop Foreign Key dialog appears.

  9. Select a foreign key.
  10. Select either of the following:

    • Restrict: If constraints are dependent on this constraint, it cannot be dropped.

    • Cascade: If referential constraints are dependent on this constraint, those dependent constraints are dropped along with the specified constraint being dropped.

  11. Click Drop button to drop the selected foreign key