The SQL History toolbar contains icons and menus to help you manage the SQL History view and display of history records. Actions such as Delete Rows and Delete All History, in addition to removing records from the view, delete the records in the SQL history database.
Toolbar Actions
Icon | Option | Description |
---|---|---|
Delete Selected Rows | Deletes selected rows from the view and history database. | |
Filter history display | Opens a dialog to filter the display. | |
Export history | Opens a dialog to export history view items to XML file. | |
Import history | Opens a dialog to import history items from either a previously exported XML history file or SQL Assistant history file. | |
Cleanup history | Opens a dialog to clean up SQL history records based on selected criteria. | |
Format History View | Enables you to format the display. The platform-specific Font dialog allows you to select the font, size, and color (on most platforms). | |
Sort history display | Opens a dialog for setting a multi-column sort. |
Toolbar Menu Options
Icon | Option | Description |
---|---|---|
Delete Selected Rows | Deletes selected rows from the view and history database. | |
Export history | Opens a dialog to export history view items to an XML file. | |
Import history | Opens a dialog to Import history items from either a previously exported XML history file or SQL Assistant history file. | |
Cleanup history | Opens a dialog to clean up SQL history records based on selected criteria. | |
Clear Filter | Removes the current filter from the display. | |
Filter | Opens a dialog to filter the display. | |
Format History View | Enables you to format the display. The platform specific Font dialog displays to allow you to select font, size, and color (on most platforms). | |
Sort multiple columns | Opens a dialog for setting a multi-column sort. |
Context Menu Options
Icons | Option | Description |
---|---|---|
Find | Allows you to search the SQL History view for a value. | |
Find Next | Finds the next matching value in the history view. | |
Copy Row | Copies the selected rows. Rows are copied as text and as HTML. The HTML display preserves the column headers. The target to which you paste determines whether text or HTML displays. | |
Copy Cells | Copies the cell data to the clipboard. | |
Delete Row | Deletes selected rows from the view and history database. | |
Edit SQL | Edits the SQL from a selected cell in the SQL Statement column in an SQL Editor. | |
Edit Note | Edits the note from a selected cell in the Note column. | |
Reexecute statement | Re-executes the SQL from the selected cell in the SQL Statement column. |