Stored Queries

Stored Query is an internal Cross-Database Studio object that belongs to Database Connection.

This object is not stored in the backend database and appears only in the DBBalance environment.

Stored Query is an SQL statement, created with backend SQL syntax.

Create new Stored Query:

1. Right click on Stored Queries node.
2. Select Create new Stored Query. New Stored Query dialog will open.

   In this dialog you can create your SQL statements.

   Three areas are available to help you create the statement.

   The bottom area is an editable area, you can write there your SQL (using backend SQL syntax).

   In the left upper area you can see the list of tables and views. Single-Click on the name in this area would fill the right upper area with a list of columns defined for this table.

   Double-click on the table/ view name on the left area or on the column name on the left area would bring the name to the bottom text area adding it to your SQL statement.

   Once the Stored Query is prepared (SQL written) you can use the Test button to check your syntax and logic.

   Another option is to import SQL statement from text file – use Import command button and select the file from the open file dialog.

   Since Stored Query is an internal Cross-Database Studio object, you can import Stored Query form another connection object of each Cross-Database Studio Workspace.