How to create a CHECK constraint when creating a table (Enterprise Manager)

To create a CHECK constraint when creating a table

1. Expand a server group; then expand a server.
2. Expand Databases; then expand the database in which to create the table.
3. Right-click Tables; then click New Table....
4. In the Choose Name dialog box, enter a name for the table.
5. Fill in the columns as appropriate. Each row represents one column in the table.
6. Right-click the column name on which to create the CHECK constraint, and then click Properties.
7. On the Tables tab, click New.
8. In Constraint expression, enter the text of the constraint.
9. Optionally:
   • In Constraint name, enter a name for the constraint if different from the default name supplied.
   • Select Check existing data on creation to apply the new CHECK constraint to existing data in the column(s).
   • Clear Enable constraint for INSERT and UPDATE to disable the constraint when new data is added to the table or when existing data is updated in the table.
   • Clear Enable constraint for replication to disable the constraint when the table is replicated in another database

See Also

Creating and Modifying CHECK Constraints