Executed SQL History


Upon successful execution of any single query by any execution method (see executing SQL queries), the query is stored within the editor's history cache for later reference and retrieval. The number of stored queries within the history is configurable within the user preferences. Stored queries, survive the shutting down of the application and are available when restarting Execute Query.

Selecting any previously executed query from the history cache shall populate the current Query Editor with that query overwriting any text that may be present.

The SQL history cache may be scrolled using the Previous and Next Statement buttons from the editor's toolbar. All currently stored queries may be viewed and searched at any time using the SQL History dialog as outlined below.

  1. Select SQL Command History button from the editor's toolbar (shortcut - Ctrl+H)
  2. To search for a query:
    1. Enter the search term within the dialog's Find text field
    2. Select the Search button or press the ENTER key
    3. The first appearance of the search term will be selected in the list
    4. Select the Search button again to find further values that match the search criteria.
  3. Select the query from the list to have it pasted into the Query Editor by either using the dialog's Select button or by double-clicking the query