Viewing SQL Preview for Data Updates - Teradata Studio

Teradata Studio User Guide

Product
Teradata Studio
Release Number
15.12
Published
August 2016
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
cev1468860002862.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
lifecycle
previous
Product Category
Teradata Tools and Utilities

After you make an edit, you can preview the generated SQL DDL statements. The SQL DDL statement includes updates and other changes that are submitted to the database when you save your changes.

  1. Make one or more edits in the Table Data Editor.
  2. Click the SQL Preview icon in the toolbar.
  3. Review the generated SQL in the SQL Preview text box.
  4. If you find an incorrect data update, return to the Table Data Editor and make further edits to correct it.
  5. Click Close to return to the Table Data Editor view.