Create Query

To create a new query in Query Editor

• Select anywhere on the object pane.
• Click the New Query from the object pane toolbar.
  or
• Right-click and select New Query from the popup menu.
• Edit query text on the Query Editor tab.

To create a new query in Query Builder

• Select anywhere on the object pane.
• Click the New Query from the object pane toolbar.
  or
• Right-click and select New Query from the popup menu.
• Edit query on the Query Builder tab.

To create a new query with loading from a SQL file

• Select anywhere on the object pane.
• Click the New Query from the object pane toolbar.
  or
• Right-click and select New Query from the popup menu.
• Click Load.

Hint: To create new query you can also right-click the Queries node of the navigation pane and select the New Query from the popup menu.

To create a new query with the same properties as one of the existing queries has (using drag and drop method)

Apply to:

current database {same connection}

• Select the query(s) for copying in the navigation pane/object pane.
• Right-click and drag the chosen query(s) to the target location.
• Select one of the following options:
  
  • Copy here
  • Move here
  • Cancel
• The newly created query(s) will be named as "queryname_copy"

Apply to:	different database {same connection}
	different database {different connection}

• Select the query(s) for copying in the object pane.
• Drag and drop the chosen query(s) to the target database.
• Select one of the following options:
  
  
  • Copy here
  • Move here
  • Cancel

To create a new query with modification as one of the existing queries

• Select the query for modifying in the navigation pane/object pane.
• Right-click and select the Design Query from the popup menu.
  or
• Click the Design Query from the object pane toolbar.
• Modify query on the Query Editor/Query Builder tab.
• Click Save As.

Hint: Queries(.sql) are saved under the Settings Save Path.

Edit Query

To edit the existing query

• Select the query for editing in the navigation pane/object pane.
• Right-click and select the Design Query from the popup menu.
  or
• Click the Design Query from the object pane toolbar.
• Modify query on the Query Editor/Query Builder tab.

To change the name of the query

• Select the query for editing in the navigation pane/object pane.
• Right-click and select the Rename from the popup menu.

Open Query

To open a query (manage query data)

• Select the query for opening in the navigation pane/object pane.
• Right-click and select the Open Query from the popup menu or simply double-click the query.
  or
• Click the Open Query from the object pane toolbar.

Note: Only SELECT queries will be run automatically with results being displayed on Result tab.

Run Query

To run a query

• Create a new query/open the existing query.
• Click Run. (Click Stop to terminate the running)
  
• View/edit the returned data on the Result tab.