what is difference between primary key and unique key
?
Answer Posted / chandonline
Basic difference between primary key and unique is that primary key is used to define a table in other tables for preventing data from anomalies,and unique key is used in a table to apply unifications among different values or columns of a tables and only in that table obviously.Their is no usage of unique key outward a table but primary key is often used to make relations between other tables.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are the types of database model?
Explain what a database is?
Why does this query return 0?
What is DB Development software?
In which table collections errors are stored.
How to generate OIDS
You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?
Can an extended stored procedure be called from inside a user-defined function?
Where is dbms used?
What are the 18 schemas?
State the acid rules?
Explain about normal forms?
explain detail about ftp in datastage?
Explain about the hierarchical model of the database?
I have a few records all are same structures data, I want to store data in multiple targets how