Database Integrity

See Also

USoft Developer evaluates all relevant constraints when data in the database is manipulated. It concludes which constraints are relevant for a particular manipulation on the basis of the scope of the constraints. The scope is determined by the set of tables referred to in the FROM clause, and by the columns named in the WHERE clause of the SQL statement that you have defined for the constraint.

If any database manipulations are performed as a side effect of constraint evaluation, USoft Developer investigates whether these side effects perhaps violate other constraints. If they do, the original manipulation is rejected.