How to automatically detect primary key and secondary key of SQLite when opening the db file directly in JMP 16?Hi there, I'm using C# and EFCore to create a SQLite Database.
The code is from Getting Started - EF Core | Microsoft Learn, and opening it using File -> Database -> Query Builder automatically detects primary and foreign keys:
However, if I drag the file to JMP, the keys are not automatically detected, hence making joining tables painful.
Is there a way to let JMP 16 detect keys automatically when opening sqlite file in this way?
Data AccessRe: How to automatically detect primary key and secondary key of SQLite when opening the db file directly in JMP 16?In this case, you'd want to use the ODBC driver for SQLite for key support.
Can you create a wish list item for this since keys aren't currently supported in your scenario.
Auto joins are suggested based on names and data types (when keys aren't known), but keys are definitely helpful.
Re: How to automatically detect primary key and secondary key of SQLite when opening the db file directly in JMP 16?Thanks Bryan, already did in Automatically detect primary key and foreign key of SQLite when opening the data... - JMP User Community
