What is the difference between UNIQUE KEY and UNIQUE INDEX?
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
What are the 3 types of behavioral triggers?
What are the uses of merge?
What is the process of debugging?
How to check if a column is nullable before setting to nullable?
What is data control language (dcl)?
Can we use rowid as primary key?
what is try_catch block in procedure
How does postgresql compare to "nosql"?
What is the starting oracle error number?
What is foreign key sql?
What is view? Can we update view
What are the sql aggregate functions?
what is 'mysqlimport'? : Sql dba
What is the difference between inner join and left join?
How many types of triggers are there in pl sql?