|
The Query Analyzer is one of the most powerful
Tools in Aqua Data Studio, and is the foundation of the
application's functionality. The SQL statements and queries
normally run within a database commandline interface can be typed
within the Query Analyzer and executed (CTRL + E). Aqua Data Studio
also vastly expands the commandline capabilities of each database
vendor with the addition of statement
autocompletion,
customizable syntax highlighting, advanced chart
scripting, statement formatting
and source code beautification, server side comments
and client side comments, morph
to delimited list, parsing and much more. In combination with
Aqua Data Studio's integrated source
control clients for CVS and Subversion (SVN), the query
analyzer automatically display differences between current edits
and a source control repository as edits are being typed.
When queries are executed in the Query Analyzer their results
can be displayed in several ways; as text, text history, grid,
pivot grid and execution plans. Statistics on a query run from the
Query Analyzer and its script details are also available within a
tab. The section describing Query Analyzer's
Results tabs gives further details.
The contents of the Query Analyzer can be saved in a
variety of ways and in a variety of formats and encodings, allowing
reuse as scripts within Aqua Data Studio or for emailing and
sharing. Any of the commands executed from within the Query
Analyzer can also automatically be stored in The SQL
History.
Many of the common SQL CREATE, DROP and INSERT statements that
can be typed in the Query Analyzer are also available as right
click menu items within the Schema Browser for visual
editing. The same statements and commands a database
developer or DBA would need to run on a database's proprietory tool
or commandline interface for database administration exist within
Aqua Data Studio's DBA Tools.
Using the Keyboard combination CTRL + Q , Launches the
Query Analyzer.
The Keyboard Combination CTRL + E executes the queries in
the Query Analyzer.
The Keyboard Combination CTRL + ALT + ENTER execute
edits the current query in the Query Analyzer. This allows Editing of Table
Data.
To execute Explain Plans for a
query for tuning from the Query Analyzer, use CTRL + SHIFT +
ENTER.
|
