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 is natural join in sql?
Lookups are a key component in sql server integration services (ssis). Explain its purpose?
What is scalar and vector?
Which language is used in sql?
Why partition by is used in sql?
Can we use delete in merge statement?
What is indexing in sql and its types?
Why is partition used in sql?
How do I use google cloud in sql?
What operators deal with null?
What is difference between stored procedure and trigger?
What is sqlerrm?
Is grant a ddl statement?
How we can update the view?
What is materialized view in sql?