Visual Column List ordering in SQL window

SaKa

Member²
Hi,
In SQL Window when you use the table alias and press the dot, it drops down the columns of the table to choose from. This is very useful and i use it often. Since recent update i noticed this order of the column list changed to alphabetical. I am pretty sure it used to display that in the order of the columns in the DDL (same order the columns appear when you desc the table).

Can I have it back to that same order please? The first columns in our tables are the keys, so most of the time we just used to select by scrolling to form joins, which is now more an annoyance by only allowing us searching to know the column names in advance.

Thanks
Sak
Version 13.0.6.1911 (32 bit)
 
Last edited:
When the list of columns appears in the Code Assistant, click on the small black triangle at the bottom of the list to change the sort order from alphabetical to column

PSD_Code_Assist_Column_Order.jpg
 
oh Fantastic, exactly what i need. Hope when i tick, it stays like that. I will try it out.

Many Thanks.
Sak
 
Back
Top