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

Explain what you mean by 3 tier architecture.

631

Tell me what is the order in which the sql query is executed?

538

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

593

What is isolation levels?

574

Explain the microsoft sql server delete command?

540

What is the command dbcc checkdb used for?

541

What is Federation and Federation Member?

Why transaction is important?

572

What happens to a statement batch if there is a compilation error?

523

What is partition, how will you implement it? : sql server analysis services, ssas

613

What are approximate numeric data types in ms sql server?

597

How fixed length strings are truncated and padded?

563

what is datawarehouse?

658

What does COMMIT command do?

634

What are the different acid properties?

635