- Open table in Table Designer
- Click on Indexes toolbar button
- Add new index and change its type to unique constraint
>
>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
--sb--