What is the difference between UNIQUE KEY and UNIQUE INDEX?
- 3 Answers
- 7510 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are transaction and its controls?
How to use distinct and count in sql query? Explain
how to show all tables with 'mysql'? : Sql dba
can sql servers linked to other servers like oracle? : Sql dba
how to load data files into tables with 'mysqlimport'? : Sql dba
What is union and union all keyword in sql and what are their differences?
What are two statement types in sql?
what is a trigger? : Sql dba
Is it possible to link two groups inside a cross products after the cross products group has been created?
Which command is used to delete a package?
Mention what are the benefits of pl/sql packages?
How many types of triggers are there in pl sql?
What is inner join in sql?
Explain cursor types?
How do temporal tables work?
