cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Browse apps to extend the software in the new JMP Marketplace
Choose Language Hide Translation Bar
Wenhan
Level II

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:

Wenhan_0-1691460846847.png

 

However, if I drag the file to JMP, the keys are not automatically detected, hence making joining tables painful.  

Wenhan_1-1691461085704.png

Is there a way to let JMP 16 detect keys automatically when opening sqlite file in this way?

 

1 ACCEPTED SOLUTION

Accepted Solutions

Re: 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.

View solution in original post

2 REPLIES 2

Re: 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.

Wenhan
Level II

Re: How to automatically detect primary key and secondary key of SQLite when opening the db file directly in JMP 16?