Statement Icons - Visual Explain

Teradata Visual Explain User Guide

Product
Visual Explain
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2504
lifecycle
previous
Product Category
Teradata Tools and Utilities

Table 12 describes the SQL statement icons.

 

Table 12: Statement Icons 

Icon

Statement

Description

Abort

Terminate the current transaction.

Alter Trigger

Allow users to enable or disable a trigger, and to change its creation timestamp.

Call Procedure

Execute a stored procedure.

Create/Replace Macro

Insert or replace a macro in the database.

Create/Replace Procedure

Insert or replace a procedure in the database.

Create/Replace Trigger

Create new triggers or change the definition of a trigger.

Alter Table

Alter a specified table.

Create Index

Create an index to table.

Create Table

Alter a specified table.

Delete

Delete rows from a table.

Drop Index

Drops an index on a specified table.

Drop Table

Drops a specified table.

End Transaction

Indicate that the processing is complete and any locks on the data can be removed.

Execute Macro

Execute a specified macro.

Insert

Add rows to a table.

Merge into

Merge row or rows into a table.

End Mload

Signifies the end of a Multiload task and initiates task processing.

Begin Mload

Signifies the beginning of a Multiload import task.

Mload Job

Invokes a Multiload job.

Set Check Workload

Set check workload during Mload.

Checkpoint Loading

Threshold limits that can be assigned for a specific load for Fastload, Multiload, or TPT.

Begin Loading

Initiates the loading process.

Query Band

Sets a query band.

Roll Back

Terminate the current transaction, and reset the database to the pre‑transaction state.

Select

Retrieve specified fields from a table.

Update

Modify data in one or more rows of a table.