About Editing Table Data - 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

The Table Data Editor enables you to edit data stored in tables in a Teradata or Aster database. The editor supports very large tables and provides several additional editors for large data objects such as Character Large Objects (CLOBs) and Binary Large Objects (BLOBs). It also supports an XML Data Type Editor for editing XML data. Rows of data can be grouped into pages that allow you to quickly locate table rows. Advanced filter and sort functions in the Data Filter help you to easily find data of interest.

You can edit table data either directly in the Table Data Editor or you can export data to a Microsoft Excel spreadsheet or text file to change the data and then import it back into the table using the Load Data Wizard. Use the toolbar functions at the top of the editor to export data.

Editing data in the Table Data Editor is as simple as editing data in a spreadsheet editor. Insertion and deletion functions are similar, as well as keyboard and cursor actions.