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:
- Expand the system name and Databases.
- Expand the database that you want to work with.
- Expand the Database Maintenance folder.
- Select Check Pending Constraints.
- 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.
- You can either alter or delete the rows that are in violation.
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. |