What's the difference between a primary key and a unique
key?
- 4 Answers
- 7337 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
How do you delete a data source?
What are “lock” hints?
How to delete database objects with "drop" statements in ms sql server?
What is the concept of optimization?
What are user defined functions in ms sql server?
What is policy based management (pbm)? : sql server database administration
What is full outer join in sql server joins?
Explain what is row_number function?
What is precedence constraint?
Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?
Differentiate between a local and a global temporary table?
What is a full text index?
Why olap is used?
where the connection string store in the database
What is tabulation?
