Check constraint: Difference between revisions

Revision as of 02:22, 31 August 2006

Revision as of 02:23, 31 August 2006

Line 10:

If these constraints were not in place, it would be possible to have a negative price (-$30) or quantity (-3 items).

Check constraints are used to ensure the validity of data in a database, i.e., 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 theythe data become invalid, even if the application itself accepts invalid data.

==External link ==