Auto Column Lookup

The SQL editor provides auto column lookup. When the auto column lookup feature detects that the user has typed a potential table name or table alias, it will wait for the amount of time specified in the Auto Column Lookup Delay field in the preferences, and then make a call to get the columns for the particular table. If it finds columns for the table, it will display them in a selectable list at the current cursor position in the SQL editor.

The default auto column lookup delay is around 1 second. To make it faster or slower, change the delay value in the preferences.

To guarantee that the auto column lookup determines the correct table name, do not use the same alias name for different tables in the SQL editor.

For faster performance, the auto column lookup tool provides the ability to cache column values in memory so that they can be retrieved more quickly. This option can be set via the preferences window.