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.
Select the column to which the constraint applies in Object Explorer, Database Diagram Designer, or Table Designer.
From the View menu, click Properties Window.
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.