Hi, Just checked dbimport with sqlite, seems like driver still skips part of the information about foreign keys (or rather quite strictly follows the definition of the table). Primary key name is missing in the FK metadata in particular if FK references table without defining PK name explicitly. A work around for this would be to include PK column name in the FK definition, like "REFERENCES table(PkColumnName)". In this case JDBC driver gives all the information needed.
On Fri, Jul 22, 2022 at 5:19 PM Ali Baharev <ali.baha...@gmail.com> wrote: > > > IIRC the issue on Cayenne side was with SQLite JDBC driver not bringing over > > the FK metadata during DB import. Again, this was years ago. > > It must have been a long while ago. > > If I use it from DBeaver, I do get all the foreign keys, so the JDBC > driver has been fixed by now. > > Ali -- Best regards, Nikita Timofeev
