Revision as of 06:47, 15 April 2015 edit Cedar101 (talk \| contribs) Extended confirmed users 18,557 edits m →Common restrictions: {{code}} ← Previous edit		Revision as of 11:04, 16 September 2015 edit undo Frap (talk \| contribs) Extended confirmed users, File movers, Pending changes reviewers, Rollbackers 35,597 edits m Hyphen to minus Next edit →
Line 7: QUANTITY >= 0 If these constraints were not in place, it would be possible to have a negative price (-−$30) or quantity (-3−3 items). Check constraints are used to ensure the [[Data validation\|validity of data]] in a database and to provide [[data integrity]]. If they are used at the database level, applications that use the database will not be able to add invalid data or modify valid data so the data becomes invalid, even if the application itself accepts invalid data.

Check constraint: Difference between revisions