Table constraints

Previous Next

A table constraint is a restriction (a form of data quality) that applies to

a combination of data values in different columns of the same record (single-record or intra-record constraint), for example: "End date must be later than start date"; or

a combination of data values from multiple records within the same table or across tables, (multi-record or inter-record constraint), for example: "A passenger cannot participate in two tours that overlap in time".



collapseRestrictive table constraints
collapseCorrective table constraints
collapseDefining a restrictive table constraint
collapseDefining a corrective table constraint
collapseINVOKE constraints



See also

Domain constraints

Transitional constraints

Constraint messages

Constraint comments