June 9, 2008 at 10:26 am
Can we add a unique constraint from VSMS instead of using TSQL syntax.
June 9, 2008 at 11:02 am
No you cannot. You will have to write a TSQL.
June 9, 2008 at 11:07 am
Right click the table and bring up the designer.
In the "Table Designer" menu, click "Indexes / Keys".
Add a new item with the Add button.
Change the "Type" property to "Unique Key".
June 9, 2008 at 11:29 am
Michael's works. Another way to the same window is to drill down on the table in question so that you see the "Constraints" folder. Right click and select "New Constraint..."
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 10, 2008 at 6:05 am
I think that only adds a check constraint.
"Got no time for the jibba jabba!"
-B.A. Baracus
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply