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 RAID? What are the different types of RAID configurations?

1104

What is the purpose of update statistics and scope_identity() function?

1080

How to trouble shoot if unable to connect SQL Server

1973

What are various aggregate functions that are available?

961

What is the difference between online clustering and Offline clustering?

2391

How do I view a stored procedure in sql server?

969

What security features are available for stored procedure?

1012

How to find the list of fixed hard drive and free space on server?

1160

How to generate create table script on an existing table in ms sql server?

1130

How to write a query with a left outer join in ms sql server?

960

What is coalesce in sql server?

1037

What are the differences between decimal and float in ms sql server?

1206

What are the methods used to protect against sql injection attack?

1046

What are Spatial data types in SQL Server 2008

999

What are “lost updates”?

980