How do I set a PK:FK relationship in DB Browser for SQLite?

Question

I'm in DB Browser for SQLite and I don't see any way to set a PK:FK relationship. Can it do that?

thanks - dave

https://stackoverflow.com/questions/16537154/create-a-foreign-key-in-sqlite-database-browser — Graciano, Apr 06 '18 at 22:30

MikeT · Accepted Answer · 2018-04-06T23:45:50.103

6

When adding/editing the table Scroll right or enlarge the screen and then double-click the respective row underneath the Foreign Key heading. Select the Table and the column that the FK is to be comprised of.

edited Apr 06 '18 at 23:45

answered Apr 06 '18 at 23:38

MikeT

51,415
16
49
68

1

Thank you - I didn't notice that I could scroll right for more columns. – David Thielen Apr 12 '18 at 17:14

How do I set a PK:FK relationship in DB Browser for SQLite?

1 Answers1