How can we help you today?
Show table names in grid results
3 CommentsSorted by Oldest First
Roger Bjärevall
said
over 4 years ago
Paul,
What database and driver are you using?
We looked at this a couple of years ago if even if there is support in the JDBC specification to get the table/column names for a result set column, only a few drivers at that time properly implemented it.
Regards
Roger
Paul Gibbons
said
over 4 years ago
DB2
IBM Data Server Driver for JDBC and SQLJ
4.24.92
It sounds like it would be more than just a checkbox in the Tools menu. :)
Roger Bjärevall
said
over 4 years ago
Hi Paul,
Problem is that without the help from the JDBC driver we are unable to determine what table column each result set column corresponds to.
I will open a ticket and we will re-visit the drivers (and especially the DB2 driver) in case there has been some progress in this area.
Regards
Roger
Paul Gibbons
This has likely been answered somewhere else but I am unable to find.
I have a query that joins 13 tables and more often than not I need to see the full results (all tables and columns) of any given query. It ends up filling the grid with about 200 columns. Is there a way to have the grid show the table name next to the column name? table.column (or alias)