Managing check pending constraints

You can view and change constraints that the system has placed in a check pending state.

Check pending refers to a state in which a mismatch exists either between a parent and foreign key in the case of a referential constraint or between the column value and the check constraint definition in the case of a check constraint.

To view and change constraints that have been placed in a check pending state, follow these steps:

  1. Expand the system name and Databases.
  2. Expand the database that you want to use and expand the Database Maintenance folder. Select Check Pending Constraints.
    From this interface, you can view the definition of each constraint and the rows that are in violation of the constraint rules.
  3. Select the constraint that you want to work with and then select Edit Check Pending Constraint from the File menu.
  4. Change or delete the rows that are in violation.