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

Modifying an existing constraint definition

Once you have defined a constraint definition, you can change a subset of a constraint definition's properties. The following procedure describes how to modify a constraint definition.
To modify a constraint definition:
1. Start Data Administration and connect to the OpenEdge database you are migrating.
2. Select DataServer > ORACLE Utilities > Server Attributes > View/Maintain Foreign Constraints. The View/Maintain Foreign ConstraintDefinition dialog box appears.
3. Select the table and constraint definition you want to modify, and click Constraint Properties. The Modify Foreign Constraint Definition for tablename dialog box appears.
4. The Modify Foreign Constraint Definition for tablename dialog box is very similar to the Create Foreign Constraint Definition for tablename dialog box, with the exception being that only modifiable fields are active. Modify your constraint definition as required.
Note: If the constraint definition property you want to change is not modifiable, you can delete the existing constraint definition and define a new one.
5. Click OK to save the changes to the constraint definition and exit the dialog box. Click Create to save the changes to the constraint definition and remain in the dialog box to modify other constraint definitions.