Toad World® Forums

toad renaming my columns

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