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

**URL:** <https://forums.toadworld.com/t/how-to-show-table-names-in-column-headers-of-data-grid/32879>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [March 13, 2015, 2:04am UTC](https://forums.toadworld.com/t/how-to-show-table-names-in-column-headers-of-data-grid/32879 "2015-03-13T02:04:57Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![norren](https://avatars.discourse-cdn.com/v4/letter/n/dec6dc/32.png) [@norren](https://forums.toadworld.com/u/norren)\
**Post date:** [March 13, 2015, 2:04am UTC](https://forums.toadworld.com/t/how-to-show-table-names-in-column-headers-of-data-grid/32879/1 "2015-03-13T02:04:57Z")

</div>

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](https://global.discourse-cdn.com/quest/original/2X/7/773b02e256a532f200c75381a0d98d321d172df3.png)

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [March 13, 2015, 5:41am UTC](https://forums.toadworld.com/t/how-to-show-table-names-in-column-headers-of-data-grid/32879/2 "2015-03-13T05:41:36Z")

</div>

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…
