Autocompletion - Aqua Data Studio supports auto-completion for database tables and columns.

As the user types SQL statements the editor will analyze the SQL statement and determine whether the user can be assisted by a popup menu of options.
The editor will determine what tables and columns to prompt the user with depending on the position of the cursor. If the editor does not prompt a user for options, the user may always request "options" with the CTRL-space hot key. When writing SQL statements the user must be aware of separating statements with the appropriate statement separator ("GO" or "/") so that the editor may appropriately analyze the current statement. Having multiple statements not separated by statement separators will prevent auto-completion from providing the correct tables and columns.

The editor toolbar has 3 options which control the behavior of "auto-completion." The options are: 1) Auto-Complete, 2) Auto-on-all-schemas and 3) refresh auto-completion.

The "Auto-Complete" button will enable or disable auto-completion for the query window. "Auto-on-all-schemas" determines whether auto-completion displays a list of tables in the current user schema or all tables in all user schemas in the database. The user may always get a list of tables in a specific schema by specifing the schema name and "." (eg HR.^).

The editor will cache the schema tables and columns for auto-completion for performance purposes so any table additions or removals after the query window is open will not be available to auto-completion. You must press the "Refresh Schema" button to clear the cache.

Autocompletion Enhancements

Cross Database Autocompletion - Autocompletion for SQL Server, Sybase, MySQL and Informix now has support for completion accross databases. Indicating a table which is in a database other than the current database will now provide column completion for the correct table. Autocompleting for tables in databases other than the current one will also complete correctly. Here are some examples:

Current Database: master

Query: select * from Northwind.dbo.^Customers cu left join Example_Data.dbo.^Employees e on cu.^CustomerID = e.^EmployeeID

Completion in the locations marked with "^" will complete with the appropriate tables for the database, or the appropriate columns for the matching table

Global Autocompletion Cache - The new Global Auto Completion Cache provides an option to allow the sharing of Auto Completion schema data across different query windows. With this new option enabled, if you open 10 query windows for one registered database server, the Auto Completion schema will be stored only once and shared across all the query windows.

Quote Identifier for Autocompletion - File->Options->Scripts-> now has options "Quote Identifier for Object Table Completion" and "Quote Identifier for Column Table Completion" which will allow auto-completion to complete object/column names to be quoted on completion.