sqlitedb-browser-sqlite

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


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


Solution

  • 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.