About Check Constraints

A check constraint specifies the data values or formats that are acceptable in one or more columns in a table. For example, you can require the zip column of the authors table to allow only five-digit numeric entries.

You can define many check constraints for a table. You use the Constraints property page to create, modify, or delete each check constraint.