Open a referenced row#

Tables refer to each other through foreign keys: an order holds a customer's id, an order item holds a product's id. Database Client lets you jump straight from one of those values to the row it points at, without a join.

Right-click a cell in a column that is part of a foreign key. The menu offers to go to the referenced table, and names the option after that table. Select it to open the target table in a new tab, already filtered to the matching row. From an order's customer id, one click takes you to that customer.

The jump carries the value across as a filter, so the target tab shows exactly the referenced row or rows. If the value is empty, the menu does not offer the option, because an unset reference points at nothing.

Open a target row from results#

The same jump works in the results of a SQL query, not only in a browsed table. Where a result column comes from a real table column that participates in a foreign key, its cells offer the same go-to option. Values that Database Client cannot trace back to a single source column, such as a computed expression, do not offer it.