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 write ahead logging in DBMS?
Explain Relational Algebra in RDBMS
Which is best database?
What is the difference between a catalog and a database?
What are the two main functions of queries in databases?
what is normalization? types of normalization? example of each form? how do u implement normalization in ur project?
Explain armstrong rules? How they are complete and/or sound?
How to write udf s in delphi?
How do you backup a database?
What is atomicity in dbms?
Why are forms important in databases?
What are the different types of DBMS architecture?
What is the first step in creating a database?
What is the sql 'in' clause?
When does checkpoint occur?