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
Explain about xml databases?
Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?
Where is dbms used?
In which database can extended stored procedures be added?
Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on
How to replace not in with not exist?
Explain about post-relational databases?
Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in
Explain about normal forms?
How is data stored in dbms?
What is DB Development software?
How to use timestamp datatypes
Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card
What is the physical representation for a many-to-many relationship?
When installing the datastage7.5x2 edtion iam getting aproblem i.e the cpu count is 2 but the cpu count in installation is one . how can i install in my p.c (system is dual core).