What is the difference between UNIQUE KEY and UNIQUE INDEX?
Answer Posted / mallik
Unique Index and Unique Constraint are the same. They
achieve same goal. SQL Performance is same for both.
Add Unique Constraint
ALTER TABLE dbo.<tablename> ADD CONSTRAINT
<namingconventionconstraint> UNIQUE NONCLUSTERED
(
<columnname>
) ON [PRIMARY]
Add Unique Index
CREATE UNIQUE NONCLUSTERED INDEX
<namingconventionconstraint> ON 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.
Is This Answer Correct ? | 4 Yes | 5 No |
Post New Answer View All Answers
Is it possible to read/write files to-and-from PL/SQL?
What is db journal file?
Do we need to create index on primary key?
Can we write dml inside a function in sql server?
What is right join sql?
How do you explain an index?
what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba
What is having clause in sql?
What does a pl/sql package consist of?
What are the types of records?
Can we connect to postgresql using sql developer?
What is union and union all keyword in sql?
What is pl sql code?
How do you determine the current isolation level? : Transact sql
What is nosql db?