Adding check constraint

To add a check 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 Check Constraint.

    Add Check Constraint dialog appears.

  9. Select Let SQL/MX choose the name to generate the check constraint name automatically, else explicitly provide a check constraint name in the Name field.
  10. Enter the constraint text in the text box.
  11. Click OK to add check constraint to the table, else click Cancel to discard the changes.