Once you have defined a constraint definition, you can change a subset of a constraint definition's properties. The following steps demonstrate 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. SelectDataServer > MS SQL Server Utilities > Server Attributes > View/Maintain Foreign Constraint Definitions.

    The View/Maintain Foreign Constraint Definitions dialog box appears.

  3. Select the table and constraint definition you want to modify, and click Constraint Properties.

    The Modify Foreign Constraint Definitions for tablename dialog box appears.

  4. Modify your constraint definition as required.

    The Modify Foreign Constraints for tablename dialog box is very similar to the Create Foreign Constraint Definitions for tablename dialog box, with the exception being that only modifiable fields are active.

    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.