Adding unique constraint

To add a unique constraint:

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 Add Unique Constraint.

    Add Unique Constraint dialog appears.

  9. Select Let SQL/MX choose the name to generate the unique constraint name automatically, else explicitly provide a unique constraint name in the Name field.
  10. Select columns from the Columns Available grid and click Add to move them to the Constraint Columns grid.
  11. Click Remove to move back the columns to the Columns Available grid.
  12. Click OK to add unique constraint to the table, else click Cancel to discard the changes.