Dropping check constraint
To drop a check constraint:
Procedure
- Log on to the MXDM.
-
In the Navigation tree pane, click
Database.
MXDM displays a list of available systems in My Systems.
-
Expand a selected system in the navigation tree.
List of catalogs for the selected system appears.
-
Click and expand the contents of a Catalog.
The list of schemas appears.
-
Expand a schema in the left pane.
The Tables folder appears.
- Expand the Tables folder and select a table in the left pane.
- Right-click the table and select Alter Table from the context menu.
-
Select
Drop Check Constraint.
Drop Check Constraint dialog appears.
- Select a check constraint.
-
Select either of the following:
-
Restrict—If the referential constraints are dependent on this constraint, it cannot be dropped.
-
Cascade—If the referential constraints are dependent on this constraint, the dependent referential constraints are dropped along with the specified constraint.
-
- Click Drop button to drop the selected check constraint.