One of the most powerful tools and the foundation in the Aqua Data Studio application is the Query Analyzer. SQL statements and queries normally run within a database command-line interface, can be typed and executed within the Query Analyzer. Aqua Data Studio also expands the command line capabilities of each database vendor with the addition of statement auto-completion, customizable syntax highlighting, advanced scripting charts, 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 displays differences between current edits and a source control repository as edits are being typed.
The results, when executing the Query Analyzer, can be displayed in different ways: as text, text history, grid, pivot grid, and execution plans. Statistics run from the Query Analyzer, where you can also use the Query Analyzer Results tab to see script details and further details.
The contents of the Query Analyzer can be saved in different formats and encodings, allowing the results to be shared as scripts within Aqua Data Studio or by email. All the commands executed in the Query Analyzer can be automatically saved in the SQL History.
Many of the common SQL Create, Drop, and Insert features are also available in a right-click menu within the Schema Browser for visual editing. As part of the DBA Tools, all statements and commands a Database Developer or Database Administrator needs to run on a database proprietary tool or command-line interface are available within Aqua Data Studio's Query Analyzer.
Shortcuts:
- CTRL+Q: Launches the Query Analyzer
- CTRL+ E: To execute the queries in the Query Analyzer
- CTRL+ALT+Enter: To execute edits in the current query, it allows the use of the Table Data Editor
- CTRL+SHIFT+Enter: To execute Explain Plans for a query