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 3nf in the dbms?
Which database is faster?
What is artificial key?
What is the full meaning of dbms?
What is the use of drop command?
What is normalization and what are the different types of normalization?
What are the different types of modeling?
What is a stretch database?
What is the best way to determine whether firebird server is running?
What are the integrity rules in dbms?
What are the different technologies used to access Database from Visual Basic?
Which software is best for database?
Which database is best for storing images?
What is index and also explain types of indexing in dbms?
What is sonicmq?