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
Why does reading require write privileges on database file?
What is a clause in terms of sql?
How to use events with zebedee, ssh or stunnel?
How to do replication of firebird databases?
What is foreign key in database?
Is it possible to determine clients ip address?
Explain the role of metadata for the three-layer architecture.
What is openedge translation manager?
Define truncate and delete commands?
What is artificial key?
Can we save image in database?
What is difference between database and schema?
Explain entity, entity type, and entity set in dbms?
Which is better saving files in database or in file system?
What is dbms architecture?