what are the advantages of primary key over unique+notnull
Answer Posted / soubhagya
When we create a primary key automatically a cluster index
is created on those columns involved in primary key.But
this index not created in unique+not null key, it only
restrict the duplicate values.
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
Describe sql comments?
What is cte sql?
What is bulk collect in pl sql?
What is the difference between microsoft sql and mysql?
What is a sql profiler?
Which language is used in sql?
What is varchar used for?
What are the different types of joins in sql?
What is the cause of mutating table error and how can we solve it?
Can I call a procedure inside a function?
What is the importance of sqlcode and sqlerrm?
What are the two types of periodical indexes?
Can you do multiple joins in sql?
What is t sql in sql server?
What does the file extension accdb stand for?