SQL Query History

The SQL Query History window allows you to view, search, and edit the executed queries. To open the window, click on the SQL toolbar. Alternatively, on the View menu, point to Other Windows and then click SQL Query History.

Setting Up SQL Query History behavior

To set up behavior of SQL Query History:

  1. On the Tools menu, click Options.
  2. In the Options dialog box that opens, navigate to Environment, Documents, SQL Query History.
  3. To enable storing query SQL Query History, select the checkbox next to the Store executed queries within option and set the number of days to store executed queries.
  4. Optional: Modify the path to store the SQL Query History database, maximum script size to store, and timeframe for default output of SQL Query History.

Filtering SQL Query History

To find the required query:

  • Type the search string into the Search box and specify query execution time frame.
  • Use sorting, grouping, and filtering.

Editing Query

To edit an executed query, select it in the list and click Edit Query in the Query DDL section of the window. The query will open in a new SQL document.