[Keith Fetterman]

I just upgraded to 4.1.1 and I was checking out the auto completion in the SQL browser. I have a request.

The hardest thing to remember when type sql is column names. How about supporting table aliases? If I define a table alias and then type the table alias in other parts of the SQL statement, pop-up the column names. For example, if I have the following sql statement:

select i.sku, i.name from item i where i.sku = ‘20000’;

When I type “i.”, pop-up a list of the columns. If I type “i.a”, narrow the list to column names that start with “a”.

Thanks

[Riyad Kalla]

We have wanted to add this for a long time, was just an issue of management prioritizing the work to go back into the parser and add seek-ahead support for the alias to provide the autocomplete. I’ll try and bump this.

[Michael A. McAngus]

@support-rkalla wrote:

We have wanted to add this for a long time, was just an issue of management prioritizing the work to go back into the parser and add seek-ahead support for the alias to provide the autocomplete. I’ll try and bump this.

It’s over 7 years later. I’d like to +1 this request.

[support-swapna]

mmcangus,

The feature is available in MyEclipse Visual SQL Query Editor. Open the .sql with ‘MyEclipse Visual SQL Query Editor’ and you can see auto complete suggestion for table alias. Please try it out.

Please refer to this tutorial for an overview about MyEclipse Visual SQL Query Editor :
http://www.myeclipseide.com/documentation/quickstarts/vqb_overview/

Let us know if you see any issues.

[Author]

Posts