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 federation member?

What is replace and stuff function in sql server?

561

How self join is different from outer join?

601

What is sql server management studio? : sql server management studio

578

What do you mean by an execution plan? Why is it used?

528

What is the advantage of sql server?

536

What is cursor in ms sql server?

558

What is the process of indexing?

512

What do you mean by data integrity?

597

what is a deadlock? : Sql server database administration

493

How do you rebuild an identity column?

542

What is the simplest way to create a new database in ms sql server?

535

What is dbcc? Give few examples.

574

SQL Server Architecture ?

1925

How to modify an existing stored procedure in ms sql server?

527