Editing Table Data - SQL Assistant

Teradata SQL Assistant for Microsoft Windows User Guide

SQL Assistant
Release Number
English (United States)
Last Update
Product Category
Teradata Tools and Utilities

Editing Table Data

The following steps explain how to directly edit the data in a table or simple view.

Note: This functionality is not available when connected by ODBC.

1 Right-click on a Table or View name in the Database Explorer Tree, and then select Edit Table.

The Edit Table Filter dialog box appears.

2 In the Edit Table Filter dialog box, deselect any columns that you do not want in the output.

Note: 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 dialog box.