What's the difference between a primary key and a unique
key?
Answers were Sorted based on User's Feedback
Answer / swapna
Both primary key and unique enforce uniqueness of the
column on which they are defined. But by default primary
key creates a clustered index on the column, where are
unique creates a nonclustered index by default. Another
major difference is that, primary key doesn't allow NULLs,
but unique key allows one NULL only.
Is This Answer Correct ? | 16 Yes | 0 No |
Answer / ramneet
There is one more diff b/w primary key and unique key that
there is only one primary key in a table but there are more
then one unique keys in a table.
Is This Answer Correct ? | 11 Yes | 2 No |
Answer / 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 |
Answer / ramneet
Primary can be used in foregin key but unique key does not
used.
Is This Answer Correct ? | 4 Yes | 2 No |
What are the different types of collation sensitivity in sql server?
what is mean by crystal repoart? ahere we will mainly use that?
How to filter out duplications in the returning rows in ms sql server?
What is lock escalation? : sql server database administration
Explain ms sql server reporting services vs crystal reports?
What is primary key index?
When would you use a before or after trigger?
Does server sql treat char as a variable-length or fixed-length column?
What's new in sql management studio for sql server? : sql server management studio
Can an automatic recovery be initiated by a user?
Does hive support indexing?
how to do partition in sqlserver