How to a use Foreign Key in SQLite - Creating a Foreign Key Constraint in SQLite

In this video, we are going to take a look at how to use a foreign key in SQLite. Thanks for watching this video!

[Hamza_BR]

Great work man, you deserve a lot more followers, just subbed 😄

[SiddhantSaraf]

Very importantly, you forgot to mention that foreign key needs to be switched ON every time a new database connection is established! The following code must be always executed on every new connection to ask SQLite to actually honour foreign key constraints:

PRAGMA foreign_keys = ON;

[beerfilms]

In this case, which is the child and which is the parent?