What's the difference between a primary key and a unique
key?
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 to use clusters?
Write a sql query to display the current date?
Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?
How to Update from select query in sql server?
What is snapshot parameter in ssrs?
What is check constraint in sql server?
What are audit control procedures?
How to create a simple stored procedure in ms sql server?
What are the acid properties?
What is the sql server agent?
What are the database objects? : SQL Server Architecture
what is the difference between a primary key and a unique key? : Sql server database administration
What is primary key and example?
Explain logical operators in sql server?
How to include date and time values in sql statements?