# Pick lists for column names when using table aliases **URL:** \ **Category:** Toad for Oracle & DevOps Toolkit\ **Created:** [February 9, 2016, 2:19pm UTC](https://forums.toadworld.com/t/pick-lists-for-column-names-when-using-table-aliases/35053 "2016-02-09T14:19:26Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![raviSD](https://avatars.discourse-cdn.com/v4/letter/r/b2d939/32.png) [@raviSD](https://forums.toadworld.com/u/raviSD)\ **Post date:** [February 9, 2016, 2:19pm UTC](https://forums.toadworld.com/t/pick-lists-for-column-names-when-using-table-aliases/35053/1 "2016-02-09T14:19:26Z")
Hello, New user and just migrated from plsql developer. My question is below : How do I get pick lists to populate column names when I am using aliases to the tables. Importantly, I do not want to use schema name when writing every query and so I use alter session set current schema and then start querying. In other words,if I use ALTER SESSION SET CURRENT\_SCHEMA = SCOTT; select \* from emp e where e. Pick lists is not populating columns to pick from. Anything to help solve this. Much appreciated, Ravi ---
**Author:** ![mstaszew](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/mstaszew/32/23_2.png) [@mstaszew](https://forums.toadworld.com/u/mstaszew)\ **Post date:** [February 9, 2016, 4:21pm UTC](https://forums.toadworld.com/t/pick-lists-for-column-names-when-using-table-aliases/35053/2 "2016-02-09T16:21:58Z")
Look at the Editor toolbar and you’ll find a dropdown for the Current Schema. Select the current schema you’re interested in and Toad will automatically issue the necessary ALTER SESSION calls behind the scenes as needed. When done in this way Toad knows of your intentions and the pick list (Code Insight) behaves correctly as well as several other Editor features. Setting it in this way is also required for F9 execution, the traditional method of executing single statements and compiling PL/SQL. Script execution (F5) will pick up on it as you have it in your script, but that’s the only Toad feature that will act on it. We don’t parse the script and act on the ALTER SESSION for Code Insight. Your simple example wouldn’t be too an issue, but a script could call another script which could do the alter session, the new current schema could be specified by substitution variables, etc. There are too many possibilities. Use the toolbar dropdown and you’ll get the expected behavior. Michael **From:** raviSD [[mailto:bounce-raviSD@toadworld.com](mailto:bounce-raviSD@toadworld.com)] **Sent:** Tuesday, February 09, 2016 5:22 PM **To:** [toadoracle@toadworld.com](mailto:toadoracle@toadworld.com) **Subject:** [Toad for Oracle - Discussion Forum] Pick lists for column names when using table aliases **[Pick lists for column names when using table aliases](http://www.toadworld.com/products/toad-for-oracle/f/10/t/27407)** Thread created by raviSD Hello, New user and just migrated from plsql developer. My question is below : How do I get pick lists to populate column names when I am using aliases to the tables. Importantly, I do not want to use schema name when writing every query and so I use alter session set current schema and then start querying. In other words,if I use ALTER SESSION SET CURRENT\_SCHEMA = SCOTT; select \* from emp e where e. Pick lists is not populating columns to pick from. Anything to help solve this. Much appreciated, Ravi To reply, please reply-all to this email. [Stop receiving emails](http://www.toadworld.com/products/toad-for-oracle/f/10/t/27407?subscribe=false) on this subject. Or [ Unsubscribe from Toad for Oracle - General](http://www.toadworld.com/products/toad-for-oracle/f/10?subscribe=false) notifications altogether. Toad for Oracle - Discussion Forum [Flag](http://www.toadworld.com/products/toad-for-oracle/f/10/t/27407?AbuseContentId=12b1640f-ac45-4402-bce2-0b213d61d066&AbuseContentTypeId=46448885-d0e6-4133-bbfb-f0cd7b0fd6f7&AbuseFlag=true) this post as spam/abuse.