16.10 - About the SQL Editor - Teradata Studio

Teradata Studio Express User Guide

Teradata Studio
June 2017
User Guide

The SQL Editor provides an integrated environment for the development of SQL files that enable you to develop SQL statements for execution. The editor enables you to validate SQL syntax, save files to a project or export to system files, and execute all SQL in a file or execute the SQL as individual statements. You must specify a Connection Profile before you can execute an SQL query statement.

The SQL Editor displays when you open an SQL/DDL file or when you select the Query Development Perspective. Double-clicking an SQL/DDL file in the Project Explorer opens that file in the editor. You can also open the SQL Editor by clicking in the Query Development perspective.

Connection Profile Name
Selects the profile in which to run the SQL script. You do not have to connect to a Connection Profile to display the Connection Profile name in the list.
Editor Work Area
Displays the active SQL edit window. You can insert, delete, and modify SQL statements displayed in this area.
After SQL is executed, any passwords displayed in the editor will be masked. If you want to re-execute the SQL, you will need to type in the passwords.
Connection Status Indicator
Shows the status of the connection to the selected Connection Profile. Green indicates that the connection is active.
Autocommit Toggle
When selected, submits each SQL statement in autocommit mode. Each SQL statement is then executed in its own transaction that ends with a COMMIT statement. You cannot roll back an SQL statement that is executed in autocommit mode. When Autocommit is set to ON, the Autocommit check box in the toolbar is selected. To turn Autocommit OFF, clear the check box.
Max Rows
Changes the maximum number of rows returned by SQL executed in this editor.
SQL Execution Options
Displays a list of Execute options. You can select to Execute an Individual Statement that you have selected, or to Execute All query statements in the editing pane.
SQL Editor Toolbar
A set of tools to manage and execute SQL.
Content Assist
Provides aids for validating, debugging, and editing the SQL queries you develop in the editor. You can use the Text Editors preference settings ( Window > Preferences > General > Editors > Text Editors) to change the appearance of the SQL Editor, including displayed tab widths, color options, line numbers, hover overs, and more.