воскресенье, 23 января 2011 г.

SQL SERVER – Difference Between Unique Index vs Unique Constraint


Unique Index and Unique Constraint are the same. They achieve same goal. SQL Performance is same for both.
Add Unique Constraint
ALTER TABLE dbo.<tablenameADD CONSTRAINT<namingconventionconstraintUNIQUE NONCLUSTERED(
<
columnname>
ON [PRIMARY]
Add Unique Index
CREATE UNIQUE NONCLUSTERED INDEX<namingconventionconstraintON dbo.<tablename>
(
<
columnname>
ON [PRIMARY]
There is no difference between Unique Index and Unique Constraint. Even though syntax are different the effect is the same. Unique Constraint creates Unique Index to maintain the constraint to prevent duplicate keys. Unique Index or Primary Key Index are physical structure that maintain uniqueness over some combination of columns across all rows of a table. It is a convenient way to enforce a Unique Constraint for SQL Server.

Комментариев нет: