Query Development | Cleanup History | Teradata Studio/Studio Express - Cleanup History - Teradata Studio

Teradata® Studio™ Express User Guide

Product
Teradata Studio
Release Number
17.00
Published
January 2021
Language
English (United States)
Last Update
2021-01-11
dita:mapPath
ovm1576517377363.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2042
lifecycle
previous
Product Category
Teradata Tools and Utilities

Use the Cleanup History dialog to delete SQL History records based on selected criteria.

Option Description
Delete SQL History using a criteria Delete records based on the following criteria:
  • Date deletes records from the SQL History view when the Timestamp column value is less than the selected date.
  • Source deletes records from the SQL History view when the Source column matches the entered value
  • SQL Statement deletes records from the SQL History view when the SQL Statement column is a super set of the entered value.
  • Notes deletes records from the SQL History view when the Notes column is a super set of the entered value.
  • User ID deletes records from the SQL History view when the User ID column matches the entered value.
  • Queries that failed deletes records from the SQL History view when the query execution failed.
  • Rows with empty Notes deletes records from the SQL History view when the Notes column value is empty.
Delete duplicate queries in SQL History Deletes duplicate SQL query records from the SQL History view.
Compact unused disk space allocated by SQL History Releases allocated disk space not used by the SQL History view. After the command executes, restart the application to make the disk space available.