Course Content

  • learnvern-1
  • learnvern-2

Course Content


Foreign key in mysql is used to link one or more than one table together. It make it possible to create a parent-child relationship with the tables.The parent table holds the initial column values, and column values of child table reference

A foreign key is the name by which the database knows that other table. It is to the same other table as an index number is to a table. Foreign keys are always followed by a period and are not nullable. Foreign keys should not be used to enforce referential integrity because the database will do this for you.To drop foreign keys using the command line, enter: ALTER TABLE name DROP FOREIGN KEY foreign_key_name

Foreign key is a key in one primary key column or multiple columns in your database that references the primary key of another table. Foreign keys are of two types: referential and master/dependent. Foreign keys have referential meaning if they are referenced in the primary key column of the table on which they are created. Foreign keys have master/dependent meaning if they are referenced in the columns that form part of the primary key of another TRIGGERS

Recommended Courses

Share With Friend

Have a friend to whom you would want to share this course?

Download LearnVern App

App Preview Image
App QR Code Image
Code Scan or Download the app
Google Play Store
App Store
397K+ Downloads
App Download Section Circle 1
4.57 Avg. Ratings
App Download Section Circle 2
13K+ Reviews
App Download Section Circle 3
  • Learn anywhere on the go
  • Get regular updates about your enrolled or new courses
  • Share content with your friends
  • Evaluate your progress through practice tests
  • No internet connection needed
  • Enroll for the webinar and join at the time of the webinar from anywhere