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

Showing Answers 1 - 2 of 2 Answers

Sheena

  • Jul 6th, 2006
 

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.

Foreign Key

Advantage

1)It allows refrencing another table using the primary key for the other table

  Was this answer useful?  Yes

Disadvantages:

On primary key index will be created so during updation of table index need to be adjusted accordingly. this process makes the updation slower.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Answer Question

Click here to Login / Register your free account


 
Send   Reset

 

Related Answered Questions

 

Related Open Questions