How to: Show Check Constraint Properties (Visual Database Tools)

You can display properties for a constraint in the Properties window from Object Explorer, Database Diagram Designer, or Table Designer.

To show constraint properties in the Properties window

  1. Select the column to which the constraint applies in Object Explorer, Database Diagram Designer, or Table Designer.

  2. From the View menu, click Properties Window.

  3. Use the dropdown list at the top of the Properties window to navigate down to the object you want. Navigate back up to the parent object and back down to see the properties of a different object.

The properties for the constraint are now visible in the Properties window.

See Also

Other Resources

Working with Constraints (Visual Database Tools)
Working with Keys (Visual Database Tools)
Indexes/Keys Dialog Box (Visual Database Tools)

Help and Information

Getting SQL Server 2005 Assistance