Multi-Record Constraints

Previous Next

See Also

A multi-record constraint refers to columns from more than one table. Multi-record constraints are handled the same way as single-record constraints.

All columns in the constraint text contribute to determine whether the constraint is multi-record or not. Accordingly, all constraints that contain joins or subqueries have multi-record scope. This is true even if a table is joined with itself.

Related Topics

Restrictive Multi-Record Constraints

Corrective Multi-Record Constraints