Manage Check Pending Constraints columns

 

You can view and change constraints that have been placed in a check pending state by the system. Check pending refers to a state in which a mismatch exists 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 constraints that have been placed in a check pending state, follow these steps:

1. Expand the system name and Databases. Right-click the database that you want to use, and select Manage check pending constraints.

2. 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.

3. 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
Enabled	Displays whether the constraint is enabled. The constraint must be disabled or the relationship must be taken out of the check pending state before any input/output (I/O) operations can be performed on it.

 

Parent topic:

Optimizing query performance using query optimization tools