Is it possible to see a foreign key value on the fly without going to another table?

Answered

In some other database management systems there is a possibility to see a foreign key value on the fly.

Here is the example from DBeaver:

 

I press the number 2 and I immediately can see that 2 means "Harry Chapin".

Is there such functionality in DataGrip?

1
2 comments
Avatar
Yuriy Vinogradov

Sure, press CTRL+Q (quick doc action) on a cell and you'll see related value.

3

on mac:
CMD + B
or
CMD + (down button)

https://www.jetbrains.com/help/datagrip/navigating-through-the-source-code.html

or press right click on this foreign key, than "GO TO" >> "REFERENCED ROWS"

0

Please sign in to leave a comment.