Toad World® Forums

How to show table names in column headers of data grid?

If I execute a very complex SQL query in Toad for Oracle 12.1.0.22 via the SQL Editor and the statements returns several columns from different tables which have the same name (e.g. ID) in the datagrid the Column Headers are renamed to ID_1, ID_2 and so on. However, if I want to figure out later to which table the column belongs this can get quite tricky, especially if I don’t restrict the columns to be returned but use the * wildcard.

Is there a way to easily identify what is the source table for a column in the datagrid?

columns.png

Oracle renames the columns in the result set. They should be in whatever order they appear in your query, but there’s nothing you can click or hover your mouse over to get the answer…