Interested to Buy Any Domain ? << Click Here >> for more details...
What's the difference between a primary key and a unique
key?
- 4 Answers
- 8737 Views
- I also Faced
- E-Mail Answers
Answer Posted / gowthami radhakrishnana
1)primary key uses clustered index
unique key uses non-clustered index
2)primary key doesn't allow null values
but unique allows one null value
3)there is only one primary key but more than one unique
keys
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What methods do you follow to protect from sql injection attack?
you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration
What is table-valued sub query?
You want to use a perspective in an mdx query. How do you select the perspective?
Explain cursor as data base object?
Why would you use sql agent?
What is the difference between commit and rollback?
What is NOT NULL Constraint in sql server 2012?
What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?
How to get @@error and @@rowcount at the same time?
What do you understand by triggers?
What is resource governor in sql server?
What are diverse clauses that form a part of sql?
What is merge?
Can you please explain the difference between primary keys and foreign keys?
