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.

Note   Some databases have different functionality for check constraints. For more information about the differences between databases, see Database Server Considerations. Consult your database documentation for details about how your database works with check constraints.

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

To See
Attach a check constraint to a table to specify the data values that are acceptable in one or more columns Attaching a New Check Constraint to a Table or Column
Create a constraint expression to check data for a condition Defining a Check Constraint Expression
Change the constraint expression or the options that enable or disable the constraint for specific conditions Modifying a Check Constraint
Apply constraints either to new data only or to existing data as well Checking Existing Data When Creating a Check Constraint
Disable a check constraint when data is added to, updated in, or deleted from a table Disabling a Check Constraint with INSERT and UPDATE Statements
Disable a check constraint when your table is replicated in another database Disabling a Check Constraint for Replication
Remove the limitations on data values in a column Deleting a Check Constraint