CHECK Constraints

CHECK constraints specify data values that are acceptable in one or more columns. You can also apply multiple CHECK constraints to a single column. When a table is dropped, all CHECK constraints are also dropped.

When you apply a constraint, it is automatically bound to the specified column. CHECK constraints can coexist with a rule on a column.

    To create a CHECK constraint

• In SQL Enterprise Manager's Server Manager window, double-click the appropriate table, choose the Advanced Features button, and then choose the Check Constraints tab.

  (For details, search for "constraints" in SQL Enterprise Manager Help.)

Or

• Use the CREATE TABLE or ALTER TABLE statement. (Examples are shown in the following section.)

  (For details, see the CREATE TABLE and ALTER TABLE statements in the Microsoft SQL Server Transact-SQL Reference.)