The SET INTEGRITY statement can be used to temporarily suspend constraint checking on a table. This statement can also be used to perform the following operations:
- Place one or more tables into the set integrity pending state
- Place one or more tables into the full access state
- Prune the contents of one of more staging tables
- Bring one or more tables out of a set integrity pending state by performing data validation via the constraint check
- Bring one or more tables out of a set integrity pending state without performing data validation
The basic syntax for the SET INTEGRITY statement is:
SET INTEGRITY FOR [TableName] [OFF | FULL ACCESS | PRUNE] | [IMMEDIATE CHECKED | IMMEDIATE UNCHECKED] <AccessMode>
In the preceding statement, the following applies:
- TableName: Identifies the name of one table on which to perform an integrity check or suspend...