16.20 - Editing Table Data - 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
The following steps explain how to directly edit the data in a table or simple view.
This functionality is not available when connected by ODBC.
  1. Right-click a Table or View name in the Database Explorer Tree, then select Edit Table.
  2. In the Edit Table Filter dialog, deselect any columns you do not want in the output.
    The selected columns must include a unique column or key if you plan to update the data. LOB columns do not appear in the list. Columns defined as Not Null are disabled because they are always selected.
  3. [Optional] Enter a Where clause to limit the rows returned and an Order by clause to specify the initial sort order of the displayed rows.
  4. Press OK to display the matching data in the Edit Table Filter dialog.