Possible candidates for using CHECK CONSTRAINTs to Restrict Values
Table showing possible candidates for using CHECK CONSTRAINTs to Restrict Values. Checking against values which are either physically fixed or widespread norms gives a good candidate. Checking against values which are fixed within the system itself creates marginal candidates. It depends how confident we are that the values will remain unchanged for the life of the system, or at least the life of the release. Finally, checking against an arbitrary value such as a “Maximum salary” which is likely to change is a poor candidate for a constraint.