what is the difference between unique and primary key

Answer Posted / suresh kumar somayajula

Unique Key allows NULL value and a table can have more than
one UNIQUE KEY Constraint.

Primary Key is the combination of UNIQUE+NOT NULL,means it
won't allow NULL Values and a table can have only one
Primary Key.But a table can have Composite Primary Key.

Thank you,
Suresh

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

List few restrictions that are imposed while creating views?

657


What are the 5 databases?

610


What is database connection pool size?

645


How do you create a report in a database?

600


Does google have a database program?

676






Explain concurrency transparency.

776


What is data modelling concepts?

684


What is dba stand for?

655


What are reports in a database?

677


Why do we need database?

656


How to extract metadata for the entire database?

738


Who has the largest database?

644


How to configure events with firewall?

701


What is the purpose of a database table?

619


How is data stored in a database?

659