Turning on constraint checking for a table without checking the table data

Use the Set Integrity window to turn on constraint checking for a table without checking the existing table data. 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 on constraint checking for a table.

Attention: If the selected table has a cyclical referential constraint relationship with one or more tables, you cannot use the Set Integrity window to turn on constraint checking. In this case, you must use the Command Center to issue the SQL SET CONSTRAINTS command. (For information on the syntax of the SET CONSTRAINTS command, see the SQL Reference .)

Fields and controls

Authorities and privileges

To turn on constraint checking for a table and not check the table data:

1. Open the Set Integrity window.
2. Select the On without checking radio button.
3. Optional: Use the Referential constraints, Check constraints, Summary, and Generated column check boxes to specify the constraint type for which you are turning on constraint checking. (Referential constraints are foreign keys).
4. Click on OK to turn on constraint checking for this table.

Related information

• Turning off constraint checking for a table
• Turning on constraint checking for a table and checking the data
• SET CONSTRAINTS command -- See the SQL Reference .

Troubleshooting tips

• Cannot turn on constraint checking