What is the difference between UNIQUE KEY and UNIQUE INDEX?
- 3 Answers
- 8030 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
Is pl sql different from sql?
Explain what is a view?
Which operator is used in query for pattern matching?
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
Explain commit, rollback and savepoint.
What is rename in sql?
Can we debug stored procedure?
how to increment dates by 1 in mysql? : Sql dba
what are sequences
Does group by remove duplicates?
what is sql in mysql? : Sql dba
Can we insert in sql function?
What operators deal with null?
what are myisam tables? : Sql dba
How many parts of a pl sql block are optional?
