Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Adding unique constraint in SSMS
Message
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01513324
Message ID:
01513342
Views:
38
>>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
Previous
Reply
Map
View

Click here to load this message in the networking platform