Page History

To execute and edit a SQL query, you have to Register a Server in Aqua Data Studio.

To make sure you are using the correct database, it is always best to launch the Query Analyzer tool from the server in the Schema tree, on the left side list.

To invoke the Query Analyzer:

• Select the Server on the Main Application menu
• Expand the Schema tree to bring up the context menu, right-click and select Query Analyzer

OR

• Click the Query Analyzer Icon on the top left of the Main Application window

1. Locate the Server and left-click it.
   Image Added
2. Click Server tab and select Query Analyzer
   Image Added
3. Right-click the server menu and select Query Analyzer
   Image Added
4. Click the Query Analyzer icon.
   Image Added

Within the Query Analyzer, there is a drop-down menu for picking other databases on the currently connected server. Multiple Query Analyzers can be open at the same time in different tabs or within additional free-floating Query Analyzer windows.

Editing Properties of a Query Analyzer in Aqua Data Studio

The properties of the Query Analyzer can be viewed and altered by selecting File > Options > Query Analyzer from the main menu. There are defaults set for the Query Analyzer in the Options Dialog, depending on the database vendor and version chosen. The preset defaults for each vendor and version have been selected based on previous user experience and supporting database documentation.

1. Click File > Options and select Query Analyzer.
   Image Added
2. Under Query Analyzer click MS SQL Server.
   Image Added
3. Set properties
   Image Added
4. Configure different vendor Options.Image Added

It is possible to establish a connection and invoke a Query Analyzer faster. Simply right-click on a registered server and select Query Analyzer As… Enter the Login Name and Password to establish the connection. A new Query window will open, with a connection already established.