unique key: allows NULL values and doesn't allow duplicate values.

what is difference between primary key and Unique

Question Posted / thaqi

Answer Posted / thaqi

unique key: allows NULL values and doesn't allow duplicate
values.

primary key:doesn't allow both NULL and duplicate values

Is This Answer Correct ?

11 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is Replication?

1051

How to drop an existing schema in ms sql server?

1103

Can you explain full-text query in sql server?

1011

What are the events recorded in a transaction log?

1000

How to stop log file growing too big?

1014

You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?

155

What are the different authentication modes in sql server?

1118

What are the different types of triggers in SQL SERVER?

1139

What does set rowcount do?

909

What is replace and stuff function in sql server?

1067

How can I create a report based on a query? : sql server management studio

1015

What are subquery and its properties?

1049

How would you go about developing a ssrs report?

168

How can I add Reporting Services reports to my application?

129

What is page in sql server?

947