|
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 according to the position of
the cursor. If the editor does not prompt a user for options, the user may always request for 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 the 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, which means
any table additions or removals after the query window is open will not be available to auto-completion. For
this reason there is a "Refresh Schema" button to clear the cache.
|
|
