Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What are the advantages and disadvantages of primary key and foreign key in SQL?

April 26, 2017advantages disadvantages foreign key primary sql

0

Posted

What are the advantages and disadvantages of primary key and foreign key in SQL?

1 Answer

0

Posted

Primary key Advantages 1) It is a unique key on which all the other candidate keys are functionally dependent Disadvantage 1) There can be more than one keys on which all the other attributes are dependent on.