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

Why does reading require write privileges on database file?

496


What is a clause in terms of sql?

591


How to use events with zebedee, ssh or stunnel?

548


How to do replication of firebird databases?

497


What is foreign key in database?

504






Is it possible to determine clients ip address?

513


Explain the role of metadata for the three-layer architecture.

527


What is openedge translation manager?

545


Define truncate and delete commands?

533


What is artificial key?

533


Can we save image in database?

510


What is difference between database and schema?

499


Explain entity, entity type, and entity set in dbms?

474


Which is better saving files in database or in file system?

482


What is dbms architecture?

590