The SQL History form provides an enhanced display of the history information. As you execute SQL statements from the SQL Editor or run functions from the Data Source Explorer, an entry is added to the SQL History list.
The SQL History form displays the data in a grid format that lets you select rows or cells, and you can copy cells or rows, sort columns, delete rows, edit the note or SQL for a history entry, filter columns, search for result history data, format the display, and re-execute SQL statements.
The SQL History uses an embedded Derby Database to manage the SQL History entries.
To re-open the form, go to .
You can add notes manually by clicking on the Note column value. You can also choose to be prompted to add notes when you execute the SQL. See Setting SQL Handling Preferences.
- Columns are movable and re-sizable. Many of the columns are grouped together under a collapsible header.
- Rows can be selected by clicking in the numbered row header.
- Column order, collapsed columns, filter, sort, and formatting are preserved from session to session.
- If a filter is in effect, the result of a newly executed SQL statement is inserted as the top row, regardless of whether it meets the filter criterion. If a sort is in effect the new entry is inserted in the sorted order.
- The Result column contains a summary of the executed SQL operation. To read the entire contents in a column cell, hover the mouse pointer over the cell. Error results show as red text in the resulting tool tip display. The following examples are samples of the Result summary.