16.20 - Working with the Edit Table Dialog - Teradata SQL Assistant

Teradata® SQL Assistant for Windows User Guide

Product
Teradata SQL Assistant
Release Number
16.20
Published
October 2018
Language
English (United States)
Last Update
2020-01-03
dita:mapPath
gfk1537201040714.ditamap
dita:ditavalPath
ft:empty
When the Edit Table dialog first appears, it is in read-only mode. To enter edit mode, do one of the following:
  • Double-click the cell to edit.
  • Navigate to the row to edit and press Enter to enter edit mode for the first column in the row. Press Tab to move to other cells in the row.

After editing a cell you can do the following:

Click or press To
Enter Accept the new value and exit Edit mode.
Tab Accept the new value and edit the next cell.
Esc Revert to the old value and exit Edit mode.
Mouse button Accept the new value and exit Edit mode.
In many cases, you cannot exit Edit mode if you enter a value that is invalid for the underlying data type. Correct the value or press Esc to revert to the original value.

After a value has been changed, the Update and Revert buttons are enabled and the background color of the row changes. The default color is gold, but it can be changed using the Code Editor tab of the Options dialog .

After making all changes, press Update to apply them to the underlying table. If all changes are successful, the background color of the updated rows revert to normal. If any rows fail to update due to table constraints and so forth, an error message appears and those rows retain their changed background. Click each row to display a message indicating the error that occurred for that row.