How to make "No Duplicates" column in SQL Server 2008?
sql-server, unique, unique-constraint
Solution
Add a unique constraint for that column:
ALTER TABLE Foo ADD CONSTRAINT UQ_Name UNIQUE (Name)
To add it through SQL Management Studio UI:
- Open SQL Server Management Studio.
- Expand the Tables folder of the database where you wish to create the constraint.
- Right-click the table where you wish to add the constraint and click Design.
- In Table Designer, click on Indexes/Keys.
- Click Add.
- Choose Unique Key in the Type drop-down list.
To handle a situation where a unique constraint violation occurs, see for error 2601.
Problem
I have a simple table in my SQL Server database. This table contains two columns: `ID int, Name nvarchar(50)`. The `ID` column is the primary key for my table. I want the "`Name`" column to be "`(No Duplicates)`", like in Microsoft Access, But this column isn't the primary column. How could I do this?