54 Views

What is difference between primary key and foreign key in database?


Priyashi Kumari 13th May, 2021
Answer (1)
Palak kumari 13th May, 2021

Hi there,

Primary key is the set of attributes that uniquely identifies the records of the table. If we apply primary key in a column then we cannot add duplicate value to it.

Foreign key is a non key attributes those whose values are derived from primary key of some other table.

Hope it helps!

For further queries do, let me know!

Related Questions

Amity University, Noida Law A...
Apply
700+ Campus placements at top national and global law firms, corporates and judiciaries
Amity University, Noida BBA A...
Apply
Ranked amongst top 3% universities globally (QS Rankings)
VIT Bhopal University | M.Tec...
Apply
M.Tech admissions open @ VIT Bhopal University | Highest CTC 52 LPA | Apply now
Amity University | M.Tech Adm...
Apply
Ranked amongst top 3% universities globally (QS Rankings).
Graphic Era (Deemed to be Uni...
Apply
NAAC A+ Grade | Among top 100 universities of India (NIRF 2024) | 40 crore+ scholarships distributed
Amity University Noida B.Tech...
Apply
Among Top 30 National Universities for Engineering (NIRF 2024) | 30+ Specializations | AI Powered Learning & State-of-the-Art Facilities
View All Application Forms

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books