Try OpenEdge Now
skip to main content
DataServer for Oracle
The DataServer Tutorial : Managing server attributes : Deleting an existing constraint definition
 

Deleting an existing constraint definition

Once you have defined a constraint definition, you can delete it. The following procedures demonstrate how to delete all constraint definitions or one class of constraint definitions.
1. To delete one constraint definition:
a. Start Data Administration and connect to the OpenEdge database you are migrating.
b. Select DataServer > ORACLE Utilities > Server Attributes > View/Maintain Foreign Constraints. The View/Maintain Foreign Constraint Definitions dialog box appears.
c. Select the table and constraint definition you want to delete.
d. Click Delete Constraints to delete the selected constraint definition.
2. To delete all constraint definitions or all of a particular type of constraint definition:
a. Start Data Administration and connect to the OpenEdge database you are migrating.
b. Select DataServer > ORACLE Utilities > Server Attributes > Delete Constraints. The Delete Constraint Definitions dialog box appears, as shown in the following figure .
Figure 20. Delete Constraint Definitions dialog box
c. Select the Constraint type, either ALL or a specific sub-set.
d. Click OK to delete the constraint definitions. You are prompted to confirm your decision. Click Yes to delete the constraint definitions or Cancel to exit without deleting the constraint definitions.