What is the difference between UNIQUE KEY and UNIQUE INDEX?

Answers were Sorted based on User's Feedback



What is the difference between UNIQUE KEY and UNIQUE INDEX?..

Answer / 1

There is a clear difference between the 2. A unique
constraint defines what combination of columns has to be
unique. A unique index is just a way of making sure the
above is always valid. But it's possible to have a non-
unique index supporting a unique constraint. (if the
constraint is deferable = Only has to be valid at commit
time but is allowed to be broken in the middle of a
transaction)

Is This Answer Correct ?    1 Yes 0 No

What is the difference between UNIQUE KEY and UNIQUE INDEX?..

Answer / varsha

A UNIQUE Key grantees Unique values to a column but does not sort the column data, whereas A UNIQUE Index grantees Unique values to a column and also sorts the column data.

Is This Answer Correct ?    0 Yes 0 No

What is the difference between UNIQUE KEY and UNIQUE INDEX?..

Answer / 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

More SQL PLSQL Interview Questions

What is the best sql course?

0 Answers  


What are instead of triggers?

0 Answers  


What does plvtab enables you to do when you showthe contents of pl/sql tables?

0 Answers  


what is 'mysqlshow'? : Sql dba

0 Answers  


What is pl sql block structure?

0 Answers  






when a procedure /package is getting invalidated?

4 Answers   TCS,


Which is better stored procedure or query?

0 Answers  


What is set transaction?

0 Answers  


Why we use sql profiler?

0 Answers  


What are hotfixes and patches?

0 Answers  


What are sql functions? Describe the different types of sql functions?

0 Answers  


what are the limitations of identity column? : Transact sql

0 Answers  


Categories