SQL History Toolbar - Teradata Studio

Teradata® Studio™ User Guide

Product
Teradata Studio
Release Number
16.20
Published
September 2019
Language
English (United States)
Last Update
2019-10-10
dita:mapPath
pfg1542649412202.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
lifecycle
previous
Product Category
Teradata Tools and Utilities

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.