5.3.8 Working with Saved Queries

You can create queries and save the query for later use.

As you create queries, you can save them by clicking the Save button in the Design pane. Once you save a query, you can access it later in the Saved SQL view.

Tip:

The Saved SQL view only displays queries saved in Query Builder. In SQL Commands you can view queries saved in both SQL Commands and Query Builder.

• Saving a Query
  Learn how to save a query.
• Editing a Saved Query
  Once you save a query, you can access it in the Saved SQL view and edit.
• Deleting a Saved Query
  Learn how to delete a saved SQL query.

5.3.8.1 Saving a Query

Learn how to save a query.

To save a query:

1. Build a query:

   1. On the Workspace home page, click SQL Workshop and then Query Builder.

      Query Builder appears.

   2. Select objects from the Object Selection pane.

   3. Add objects to the Design pane and select columns.

   4. Execute the query.

2. Click Save.

3. Enter a name and description and click Save.

   The saved query displays in the Saved SQL view.

Note that Query Builder does not support duplicate query names. If you open an existing query, keep the existing name, and save it again, Query Builder over-writes the existing query. If you change the name of an existing query and save it again, Query Builder saves the query again under the new name.

5.3.8.2 Editing a Saved Query

Once you save a query, you can access it in the Saved SQL view and edit.

To edit a Saved SQL query:

1. On the Workspace home page, click SQL Workshop and then Query Builder.

   Query Builder appears.

2. Select the Saved SQL tab.
3. To filter the display, you can:

   • Make a selection from the Owner list and click Go.

   • Enter a search query in the Name field and click Go.

4. To edit a query, select the appropriate name.

   The saved query appears. The selected objects display in the Design pane and the Conditions view appears.

5.3.8.3 Deleting a Saved Query

Learn how to delete a saved SQL query.

To delete a Saved SQL query:

1. On the Workspace home page, click SQL Workshop and then Query Builder.

   Query Builder appears.

2. Select the Saved SQL tab.
3. Select the queries to be deleted and click Delete Checked.