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:
01513326
Views:
45
>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.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform