Retrieve Table Rows using a SELECT Template | Teradata Studio/Studio Express - Retrieving Table Rows using a SELECT Template - Teradata Studio

Teradata® Studio™ User Guide

Product
Teradata Studio
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-20
dita:mapPath
rvy1605890559220.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
lifecycle
previous
Product Category
Teradata Tools and Utilities
  1. In the Data Source Explorer, navigate to the Vantage or Aster database table in which you want to retrieve rows.
  2. Right-click the table object and select one of these options:
    For Select
    Vantage Teradata > Generate SQL > SELECT Statement
    Aster Database Aster > Generate SQL > SELECT Statement
    Hadoop File System Hadoop > SELECT Statement
  3. In the SQL Editor, review the generated SELECT statement and edit as needed.
  4. Click "" to execute the SELECT statement to retrieve the row in the table and view it in the Teradata Result Set Viewer.