Multi-Record Constraints

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.