Set column as unique in SQL Server from the Management Studio 1. Open SQL Server Management Studio. 2. Right click your Table, click "Design". 3. Right click the column you want to edit, a popup menu appears, choose "Indexes/Keys". 4. Click the "Add" Button. 5. Expand the "General" tab. 6. Choose the Columns to make unique selected in the "columns" box. 7. Change "Is Unique" to "Yes". 8. Click "Close". 9. Save the Database. Reference: https://stackoverflow.com/questions/5181877/how-can-i-create-a-unique-constraint-on-my-column-sql-server-2008-r2