Primary key
1. Define the Unique value in the table
2. Does not make link between table
3. Cannot have null value
4. Only one primary key per table
Foreign key
1. It is the column that references the column of another table
2. Make link between table
3. Can have null value
4. Several foreign key allowed
---------------------------------------------
Chapter:
0:00 Introduction
0:13 Primary key vs foreign key
1:25 Demo
2:01 Primary key table
5:19 Foreign key table
---------------------------
SQL Oracle playlist: https://youtube.com/playlist?list=PL0NK-I6qJ8Kxv9j8xaa4-f6Wm7NJjMHpP
Git: https://github.com/Kirubason/SQL_Queries
sql tutorial for beginners in tamil, interview questions and answers for experienced and for freshers, sql full course, sql tutorial, sql lecture, pl/sql interview questions and answers, oracle sql tutorial, oracle interview questions and answers for experienced.
#மைக்காடெக் #micah #kirubason #கிருபாசன்