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 are the 4 main objects of a database?
Is filemaker pro a relational database?
What is the difference between indexes,views,synonyms?
What are the four components of a database system?
State at least four kinds of indexing?
What is ddl in dbms?
What is rdbms data?
Explain, why is rdbms better than dbms?
Which is better saving files in database or in file system?
Where is the data stored in a database?
What are the different types of keys in the database?
What is an extensible database?
What are the different type of relationships in the dbms?
How data are stored in database?
What is dbms used for?