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?