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

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

Wenhan — Tue, 08 Aug 2023 02:25:00 GMT

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?

bryan_boone — Mon, 14 Aug 2023 13:51:39 GMT

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 — Tue, 15 Aug 2023 08:38:50 GMT