SQL Query Control

Studio includes a number of functions that aid in running SQL queries. These are found in the SQL Query area at the bottom of the Studio workspace.

These include two displays:

1. Query Area - displays the query currently edited; includes an apparatus for selecting a Server, Database, and Schema; also includes function buttons for controlling the query. When navigating through the tree the Server, Database and Schema fields will change according to the selected Server's structure.  

2. History of Queries - displays a history of queries run.  

SQL Query Control

To run an SQL query:

1. In the query area, enter the query you wish to run using correct SQL syntax.  

2. Use the controls to the right of the query area to select the Server, Database, and Schema (if applicable) you wish to query.

3. Select or press CTRL+Enter.
   The query runs on the selected location and displays the results in the query area. Queries that do not return result sets, like Update and Insert, will display the number of affected rows in the SQL Messages tab.  

4. Query history can also be accessed by selecting a query and executing it from the right-click menu, and pressing the 'Go' option or by pressing CTRL+Enter.  

Note:

Double-clicking a history item will place the history query text into the query editor area for editing and re-executing.