Single-Record Constraints

Previous Next

The scope of a single-record constraint is restricted to the columns of 1 table. In the constraint SQL you use a single table name in the FROM clause.


Consider the business rule: "A reservation can only be canceled after the reservation is booked." This rule is implemented by a restrictive single-record constraint:

SELECT    '' violation
FROM      reservation
WHERE     cancel_date < book_date


The Rules Engine validates single-record constraints at record validation time, when the record is stored. Corrective single-record constraints are validated before restrictive single-record constraints.

See Also

Restrictive Single-Record Constraints

Corrective Single-Record Constraints