The Columns of the History Window - SQL Assistant

Teradata SQL Assistant for Microsoft Windows User Guide

SQL Assistant
Release Number
English (United States)
Last Update
Product Category
Teradata Tools and Utilities

The Columns of the History Window

Table 29 lists the columns that appear in the History window.

If the Query text is longer than 1000 characters, it is truncated to 1000, and followed by ellipses (…). To view the entire text either click on it (to copy it to the Query window) or use the Edit History screen.


Table 29: The History Window Column Descriptions 

Column Name



The date and time at which the query ended.


The data source name used.


The total elapsed time for the query.


  • Teradata only: The number of rows matching the query submitted.
  • Other databases: The number of rows returned or changed.
  • See the second note below.


    The result message. See the first note below.


    The note the user attached to the query.

    SQL Statement

    The query text.

    SQL Type

    The type of database accessed.


    The length of the query, in characters.


    The number of statements in the query.

    Stmt Type

    A list of statement types used in the query. For example, CREATE TABLE, INSERT, SELECT.

    User ID

    The user ID logged on.

    DBMS Time

    The time spent within the database.

    Fetch Time

    The time taken to return the data.

    Seq (sequence)

    The order the query was submitted to the database.

    Note: The History grid displays a Result column instead of the full SqlMessage information. This column is blank unless an error occurred. To see the full Result message, position the mouse so that the cursor is over the Result cell.

    Note: For Teradata systems only, if you abort a query in progress or decline to continue when the output limit is reached, the Rows column tells you how many rows matched the query you submitted rather than the number of rows that were actually returned to the PC. Other databases still report only the number of rows returned.