Query Window -
Autocompletion
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 identify the list of tables and
columns from the Database and prompt the user 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. While 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 Features
Cross Database Autocompletion - Autocompletion for SQL
Server, Sybase, MySQL and Informix 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.
Below 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 Global Auto Completion
Cache provides an option to allow the sharing of Auto Completion
schema data across different query windows. With this 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
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.
|
