What is the difference between UNIQUE KEY and UNIQUE INDEX?
- 3 Answers
- 7511 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?
Why are cursors used?
How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?
how to drop an existing index in mysql? : Sql dba
Can we edit a view in sql?
how many tables will create when we create table, what are they? : Sql dba
how to return query output in html format? : Sql dba
What are the different type of joins in sql?
How many sql commands are there?
What are the disadvantages of not performing database normalization?
Can we call dml statement in function?
what is a primary key? : Sql dba
What is the difference between delete and truncate statement in sql?
how to include character strings in sql statements? : Sql dba
which operator is used in query for pattern matching? : Sql dba
