Diagram not showing relation? Foreign Key constraint is there...

Hello!

I'm currently trying out DataGrip and am facing a dead end here. I have created a very basic database in another program and DataGrip actually gets the data right, but it doesn't show the relation. I didn't find anything I had to enable to get this to work.

 

you can see the book_fk, but it doesn't show up in the diagram.

Any ideas?

6 comments
Comment actions Permalink

I have the same problem using SQLite. With MySQL works fine. I believe this is because SQLite does not enforce foreign keys (http://sqlite.org/foreignkeys.html)

0
Comment actions Permalink

Hello,

It is known issue with table relations not displaying. Please vote and follow related requests in YouTrack: https://youtrack.jetbrains.com/issue/DBE-1781https://youtrack.jetbrains.com/issue/DBE-2130 .

1
Comment actions Permalink

Any fix expected soon?

0
Comment actions Permalink

Currently I have no ETA for this. Most probably not in the nearest DataGrip versions.

0
Comment actions Permalink

Any update? I see foreign keys for MySQL just fine but they're missing altogether for DB2. DbVisualizer has no issues with it.

0
Comment actions Permalink

I have also run into this issue. Is there any chance that we'll be getting a fix?

0

Please sign in to leave a comment.