Does anyone know about a Database IDE (such as Sql Server Management Studio, PL/SQL Developer, Toad) that differentiates columns from different tables in the result set ?
I mean, something like coloring the columns from each distinct table in the result set with a different color.
And further (but less important) single out key columns (like PKs and FKs, printing them in bold).
Very often I found myself writing queries spanning several tables so I can get all the data I need in a single structure - and it would be useful to have such UI features to make analyzing the data pretty straightforward.
Here's an example to illustrate what I described above:
A, B and C are the tables.