What is the difference between primary and foreign key?

Answer

• Primary key uniquely identify a relationship in a database, whereas foreign key is the key that is in other relation and it has been referenced from the primary key from other table.
• Primary key remains one only for the table, whereas there can be more than one foreign key.
• Primary key is unique and won’t be shared between many tables, but foreign key will be shared between more than one table and will be used to tell the relationship between them.

All rdbms Questions

Ask your interview questions on rdbms

Write Your comment or Questions if you want the answers on rdbms from rdbms Experts
Name* :
Email Id* :
Mob no* :
Question
Or
Comment* :
 





Disclimer: PCDS.CO.IN not responsible for any content, information, data or any feature of website. If you are using this website then its your own responsibility to understand the content of the website

--------- Tutorials ---