How to set a table field unique in SQL Management Studio

How to set a table field unique in SQL Management Studio

1. Right click on Table –> Design
2. Right click on particular field eg Name, click on Indexes/Key

sql03
3. Click on Add, it create default key constraint and under Columns change to table field name

sql02
4. Is Unique set to Yes

sql01

Leave a Reply

Your email address will not be published. Required fields are marked *