Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between UNIQUE KEY and UNIQUE INDEX?
- 3 Answers
- 8905 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 is set serveroutput on in pl sql?
What is the difference between inner join and left join?
How many joins can you have in sql?
What is primary key sql?
what is a tablespace? : Sql dba
What is compound trigger?
how is myisam table stored? : Sql dba
What are hotfixes and patches?
What is the difference between inner join and outer join?
What are the types of triggers in sql?
How do you modify a trigger?
how to use myisamchk to check or repair myisam tables? : Sql dba
explain what is mysql? : Sql dba
what are the advantages of sql ? : Sql dba
What is data definition language?
