/Python/Foreign key and primary key difference

Foreign key and primary key difference

PrimaryKey:-

A primary key constrain is a column or group of columns that uniquely identifies every row in the table of the relational database management system. 
It cannot be a duplicate, meaning the same value should not appear more than once in the table.

Foreign key:-
A table can have more than one primary key. 
Primary key can be defined at the column or the table level.
If you create a composite primary key, it should be defined at the table level.
Foreign key is a column that creates a relationship between two tables. The purpose of the Foreign key is to maintain data integrity and allow navigation between two different instances of an entity. It acts as a cross-reference between two tables as it references the primary key of another table. 
Every relationship in the database should be supported by a foreign key.

Difference between primary key and foreign key

primary key and foreign key

-2

Similar codes

0 vote211 views1 answer
Python loading image file requires absolute path
Python
0 vote228 views1 answer
Set cuda visible devices python
Python
-1 vote203 views1 answer
Python unicode point to utf8 string
Python
1 vote210 views1 answer
Display max number of columns pandas
Python
4 votes221 views6 answers
Recursion in python
Python
-1 vote211 views1 answer
Unocode error pytonn
Python
24 votes247 views6 answers
Python sort dictionary by key
Python
10 votes213 views3 answers
Check python 32 or 64
Python
17 votes216 views6 answers
How to join two lists in python
Python
1 vote231 views2 answers
Select columns to include in new dataframe in python
Python