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
What is db flush?
What are the 4 main objects of a database?
How do you delete a table from database?
What are the applications of database management system?
Which is best database?
What is table normalization?
What is 2nf and 3nf?
what is storage manager?
Have you heard about sixth normal form?
What is the main purpose of normalization?
What do you mean by extension and intension?
Define ddl and dml.
Can we save file in database?
Explain the concepts of a primary key and foreign key.
Define database.