Managing check pending constraints columns

You can view and change constraints that have been placed in a check pending state by the system. Check pending constraints refers to a state in which a mismatch exists between a parent and foreign key in a referential constraint. A mismatch can also occur between the column value and the check constraint definition in a check constraint.

To view 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 work with.
  3. Expand the Database Maintenance folder.
  4. Select Check Pending Constraints.
  5. From this interface, you can view the definition of the constraint and the rows that are in violation of the constraint rules. Select the constraint that you want to work with and then select Edit Check Pending Constraint from the File menu.
  6. You can either alter or delete the rows that are in violation.
Table 1. Columns used in Check pending constraints window
Column name Description
Name of Constraint in Check Pending Displays the name of the constraint that is in a check pending state.
Schema Schema containing the constraint that is in a check pending state.
Type Displays the type of constraint that is in check pending. Possible values are:
Check constraint
Foreign key constraint
Table name The name of the table associated with the constraint in check pending state.
Enabled Displays whether the constraint is enabled. The constraint must be disabled or the relationship taken out of the check pending state before any input/output (I/O) operations can be performed.