User Community
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Don’t miss your chance to experience Discovery Summit Europe at our best available rate! Early bird registration through 31 Oct.
  • Graph Builder Toolbar streamlines interactive graphing. Creates shortcuts on Report and GraphBuilder Helpers toolbars. Download and install the extension.
  • JMP will suspend normal business operations for our Rest and Recharge Day on Friday, October 2, 2026.
    Regular business hours will resume on Monday, October 5, 2026.

JMP Wish List

We want to hear your ideas for improving JMP. Share them here.
Choose Language Hide Translation Bar
0 Kudos

Automatically detect primary key and foreign key of SQLite when opening the database file directly

Status: New Submitted by on ‎08-15-2023 04:37 AM
Comment

What inspired this wish list request? 

As the problem asked in Re: How to automatically detect primary key and secondary key of SQLite when ope... - JMP User Commu..., currently JMP can only auto detect primary-keys/foreign-keys/indexed columns by using an ODBC driver, while opening a SQLite file directly cannot. 

 

What is the improvement you would like to see?

JMP is able to detect SQLite primary-keys/foreign-keys/indexed columns without an ODBC driver. 

 

Why is this idea important? 

It would make SQLite data access a lot simpler by getting rid of adjusting table joining conditions manually.