sqlsql-serversql-server-2008unique-constraint

How can I create a unique constraint on my column (SQL Server 2008 R2)?

I have SQL Server 2008 R2 and I want to set a unique column.

There seems to be two ways to do this: "unique index" and "unique constraint". They are not much different from what I understand, although unique constraint is recommended by most, because you also get an index automatically.

How do I create a unique constraint? 

ALTER TABLE Customer ADD CONSTRAINT U_Name UNIQUE(Name)

Is there a way to create a unique constraint through the SQL Server Management Studio?

Solution

  • To create these constraints through the GUI you need the "indexes and keys" dialogue not the check constraints one.

    But in your case you just need to run the piece of code you already have. It doesn't need to be entered into the expression dialogue at all.