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

Question

In order to create a unique column, I want to use SQL Server 2008 R2. There appear to be two methods for doing this: "unique constraint" and "unique index." According to what I understand, they are not significantly different, even though most experts advise using a unique constraint because you also obtain an index immediately.

How do I establish a special constraint?

ALTER TABLE Customer ADD CONSTRAINT U_Name UNIQUE(Name)

Does the SQL Server Management Studio have a feature that allows you to define a unique constraint?

Answer 1

The "indexes and keys" dialogue, not the "check constraints" dialogue, is what you need in order to generate these limitations through the GUI. However, in your situation, all you need to do is execute the existing code. It is not at all necessary to enter it into the expression discussion.

I hope this helps you.