How to make "No Duplicates" column in Sql Server 2008 ?

Question

I have simple table in my SQL Server Database. This table contain 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?

Answer 1

Add a unique constraint for that column:

alter table Foo add constraint UQ_Name unique (Name)

To handle a situation where a unique constraint violation occurs, see for error 2601.

Answer 2

You are looking for the UNIQUE constraint.