what is the difference between unique and primary key
- 5 Answers
- 4736 Views
- I also Faced
- E-Mail Answers
Answer Posted / divyarao
primary key accepts only values which has no duplication ,and does not accept null values . for a a table there should be only one primary key constraint.
whereas in unique key ,it accepts null values .here also there should not be any duplication ,a table may have more than one unique key constarint
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are fact tables and dimension tables ? What is dimensional modeling and star schema design
What is query in rdbms?
What is snow flake schema design in database? What's the difference between star and snow flake schema?
What are functions in database?
What the default privileges which get assigned ?
What are the advantages of database management system?
How can I join two tables in database?
What is bcnf standard form in dbms?
How do I create a database in open office?
What are the types of database users?
Why are databases so important?
What's the difference between clustered and non-clustered indexes?
What do you understand by aggregation and atomicity?
What do you mean by entity type extension?
What are the characteristics of database?
