Sunday, October 31, 2010

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

1) primary key will not allow null values, foreign key will allow null values

2) primary key is unique key on which all the other candidate keys are functionally dependent. Foreign Key allows refrencing another table using the primary key for the other table

No comments:

Post a Comment