>>Hi,
>>
>>I wanted to add a unique column constraint in the SSMS but I just don't see how. Here is what I do:
>>
>>1. Right mouse click on Constraints and select New Constraint.
>>2. But somehow the SSMS opens the "Check Constraints" window.
>>
>>BTW, I know how to add this constraint in code but wanted to try it in SSMS.
>>
>>What am I missing?
>>
>>TIA
>
>This is not very intuitive:
>
http://databases.about.com/od/sqlserver/a/unique.htm>
>If you prefer to interact with SQL Server using GUI tools, you may also create a UNIQUE constraint using SQL Server Management Studio. Here’s how:
>Open SQL Server Management Studio.
>Expand the Tables folder of the database where you wish to create the constraint.
>Right-click the table where you wish to add the constraint and click Design.
>In Table Designer, click Indexes/Keys.
>Click Add.
>Choose Unique Key in the Type drop-down list.
Thank you very much.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham