what is the difference between unique and primary key

Answer Posted / divyarao

primary key accepts only values which has no duplication ,and does not accept null values . for a a table there should be only one primary key constraint.
whereas in unique key ,it accepts null values .here also there should not be any duplication ,a table may have more than one unique key constarint

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the purpose of a model?

462


How do I keep my database up to date?

510


What does rdbms stand for?

614


What is a hierarchical database?

539


Explain concurrency transparency.

582






How do you delete a table from database?

487


How we can connect the Webform pages with database?

546


What is index and also explain types of indexing in dbms?

480


How to recreate the index on a firebird table?

484


Differentiate table scan from index scan.

491


What is the main purpose of database?

495


What do you mean by Checkbox ?

1930


What is pdo in database?

490


What are rdbms concepts?

506


What are the advantages of dbms?

494