Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR PYTHON

difference between primary key and foreign key

Primary Key:
1. It is used to uniquely identify data in the table
2. It can’t be null
3. Two or more rows can’t have same primary key
4. Primary has clustered index
5. Primary key constraint can be defined on temporary table

Foreign Key:
1. It is used to maintain relationship between tables
2. t can accept the null values
3. t can carry duplicate value for a foreign key attribute
4. By default, It is not clustered index
5. It can’t be defined on temporary tables
Source by www.javatpoint.com #
 
PREVIOUS NEXT
Tagged: #difference #primary #key #foreign #key
ADD COMMENT
Topic
Name
9+2 =