Easily find issues by searching: #<Issue ID>
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
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.