Check Constraint Wizard (SQL Server)

Go Up to Microsoft SQL Server Object Wizards

Check Constraints with With CHECK and With NOCHECK tells SQL Server whether to check the rows before adding or enabling the constraint. For more information about this feature, see Check Constraint Wizard (SQL Server).

To create a new check constraint using a wizard:

1. Open a creation wizard for a check constraint. For details, see Opening an Object Wizard.
2. Use the following topic as a guide to performing tasks as you pass through the wizard panels:
   • Definition panel - for details, see Previewing the DDL Generated to Create the New Object.
3. Finally, use the Execute button to create the object.

Check Constraint (SQL Server) - Definition

When creating or editing a check constraint, this tab/panel lets you work with the following settings:

Setting	Description
Table Schema and Table Name	Identify the table for which the constraint is being created.
Name	Lets you type the name of the constraint.
Enabled	If selected, enables the check constraint.
With CHECK/With NOCHECK	Tells SQL Server whether to check the rows before adding or enabling the constraint.