# toad renaming my columns

**URL:** <https://forums.toadworld.com/t/toad-renaming-my-columns/10585>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [July 25, 2011, 10:07am UTC](https://forums.toadworld.com/t/toad-renaming-my-columns/10585 "2011-07-25T10:07:35Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![eclipsechaser](https://avatars.discourse-cdn.com/v4/letter/e/ec9cab/32.png) [@eclipsechaser](https://forums.toadworld.com/u/eclipsechaser)\
**Post date:** [July 25, 2011, 10:07am UTC](https://forums.toadworld.com/t/toad-renaming-my-columns/10585/1 "2011-07-25T10:07:35Z")

</div>

hi

i have an issue which is driving me crazy.

say I have the table

apps.po\_vendors

i am not logged into apps but another schema

say i have the select statement

select \*  
from apps.po\_vendors p

i then want to edit the select and replace the \* with a column name. I remove the \*

I enter p and then press the ^. i select the column from the drop down ie vendor\_name.

Rather than leave this as p.vendor\_name toad translates this to apps.po\_vendors.vendor\_name. I dont want this behavior. Is there a way to turn this off. i’m on 10.1.1.8