What's the difference between a primary key and a unique
key?

Answers were Sorted based on User's Feedback



What's the difference between a primary key and a unique key?..

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

What's the difference between a primary key and a unique key?..

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

What's the difference between a primary key and a unique key?..

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

What's the difference between a primary key and a unique key?..

Answer / ramneet

Primary can be used in foregin key but unique key does not
used.

Is This Answer Correct ?    4 Yes 2 No

Post New Answer

More SQL Server Interview Questions

Does the order of columns in update statements matter?

0 Answers  


Which are new data types introduced in sql server 2008?

0 Answers  


What is the Disadvantage of indexed sequential file.

0 Answers   HCL,


What is a trace frag?

0 Answers  


How do you identify a foreign key?

0 Answers  






Can you tell me some of the common replication dmv's and their use? : sql server replication

0 Answers  


What is Dedicated Administrator Connection in sql server 2005?

2 Answers  


how can we know that how many users are connected in perticuler server??????

2 Answers  


Explain try...catch with sql server?

0 Answers  


What is the difference between dbcc indexdefrag and dbcc reindex?

0 Answers  


Benefits of Stored Procedures?

0 Answers   Wipro,


What is the exact numeric data type in sql?

0 Answers  


Categories