Cleaning up the History Table - SQL Assistant

Cleaning up the History Table

Delete specific History rows by highlighting them in the History window and pressing the Delete button.

Use the Cleanup History dialog box to delete a large number of rows. This dialog box allows you to specify which rows to delete based on criteria such as the Date on which the query was executed and the Data Source against which the query was executed.

If multiple criteria are entered, only the rows matching all the criteria are deleted.

This dialog box can also be used to delete all duplicate rows from the History table. Rows are considered to be duplicate if both the Data Source and the SQL Text are an exact match.
This option is independent from the criteria specified above.

Note: This function might take a long time if there are many rows in the History table.

1 Select the History window.

2 Right-click in the History window and select Cleanup History.

3 Set the cleanup criteria as needed.

Table 32 explains the available options.

Table 32: Description of Cleanup History Options 

Cleanup History Option	Description
Date	Enter a date or click the down arrow to display a calendar to select. Place a filter operator (>, <, =,) in the operator box.
Data Source	Enter a data source name.
User Name	Enter a user name.
SQL Text	Enter text that appears within the SQL Text of the rows to be deleted. Note: See also “Using Wildcard Characters with the History Filter” on page 142.
Notes	Enter text that appears within the Notes of the rows to be deleted. Note: See also “Using Wildcard Characters with the History Filter” on page 142.
Queries that failed	Select this check box to delete all rows that display an error code.
Rows with an empty Notes column	Select this check box to delete all rows that do not have a Note assigned.