Hi Dear,
 This article we
will discuss what is the difference between primary key and
 Foreign key.
It is also a common interview question. Most of time at interview you will face
this question.
| 
        Primary key | 
        Foreign Key | 
| 
1-
  Primary key uniquely identify a
  record in the table | 
1- Foreign key is a field in the table that is primary key
  in another table | 
| 
2-  Primary
  Key can't accept null values | 
2-
  Foreign key can accept multiple
  null values. | 
| 
3-
  We can have only one Primary key
  in a table. | 
3-
  We can have more than one foreign
  key in a table | 
 
No comments:
Post a Comment