Follow foreign keys

ferenczy's profile image ferenczy posted 4 years ago in General Permalink

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?

ferenczy's profile image ferenczy posted 4 years ago Permalink

Sorry, I forgot to change the category to "Feature discussion" and I can't edit the post, so if some moderator could change it, it would be great.

Please login to leave a reply, or register at first.