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 RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
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