Turning off constraint checking for a table

Use the Set Constraints window to turn off constraint checking for a table. The table cannot be a system table.

Normally, referential integrity and check constraints on a table are automatically enforced. In some situations, you might need to manually turn off constraint checking for a table.

Note:

If you turn off constraint checking for a parent table, the foreign key constraints of all of its dependent and descendent tables are put in check pending state.

Fields and controls

Authorities and privileges

To turn off constraint checking for a table:

1. Open the Set Constraints window.

2. Make sure that the Off radio button is selected. The table will be put in check pending state.

3. Click on OK to turn off constraint checking for this table.

Related information

• Turning on constraint checking for a table and checking the data
• Turning on constraint checking for a table without checking the table data
• SET CONSTRAINTS command -- See the SQL Reference .
• Showing Commands or SQL