How Do I Create a Foreign Key in Sqlite

Open your database in Db browser,Just right click on table and click modify,At there scroll to foreign key column,double click on field which you want to alter,Then select table and it’s field and click ok.

How do I create a foreign key in SQLite studio?

1. Open your database in Db browser,
2. Just right click on table and click modify,
3. At there scroll to foreign key column,
4. double click on field which you want to alter,
5. Then select table and it’s field and click ok.

What is foreign key in SQLite?

SQLite Foreign Key is used to specify that values in one table also appear in another table. … The referenced table is known as parent table while the table with the foreign key is known as child table. The foreign key in the child table will generally reference a primary key in the parent table.