It would be great to have a possibility to "follow" foreign keys, so it's easier to browse complex databases. Let me explain.
Let's have two tables:
Table A:
column ID (int)
Table B:
column ID (int)
column A_ID (foreign key to A.ID)
When I would view data of the table B
and executed (a double click/keyboard shortcut/etc.) the "follow foreign key" feature on a cell A_ID
with value, for example, 3, it would switch me to the data view of the table A
with filter SELECT * FROM A WHERE ID = 3
, or with all data, but the row ID = 3
selected.
I hope it's understandable what I mean.
What's your opinion on such feature?