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

Use the Set Constraints 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 Constraints 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.)

Before you begin...

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

1. Open the Set Constraints window.

2. Select the On without checking radio button.

3. Optional: Use the Referential constraints and Check constraints 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

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]