Selecting to Filter by Edits - Teradata Studio

Teradata Studio IDE Plug-in User Guide

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

After you modify data in a table, you can select to view only the edited data rows. Filters are available for updated, deleted, or inserted data. This feature is useful if you've made multiple changes in a large table and want to review your changes before updating them in the database. It can also be used to group changes for export to a file, either as a record or for later review.

  1. With an edited table open in the Table Data grid, click the Filter by Edits icon in the toolbar. The Show Edits dialog opens.
  2. Select which type of edit to display by checking one or more of these options:
    1. Select the Inserts check box to display any rows with newly inserted data in the table.
    2. Select the Updates check box to display rows in which data has been added, edited, revised, or deleted.
    3. Select the Deletes check box to display rows removed from the table.
  3. Click OK. The Table Data Editor refreshes to show only table rows that match the filter options you selected.