Showing DDL Statements - Teradata Studio

Teradata Studio User Guide

Product
Teradata Studio
Release Number
16.00
Published
March 2017
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
hop1484765174877.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
lifecycle
previous
Product Category
Teradata Tools and Utilities
  1. Connect to a Teradata or Teradata Aster database. The Teradata Aster database must be version 6.10 or later.
  2. Open the Data Source Explorer and navigate to a database object.
  3. Right-click the object name and do one of the following:
    • For Teradata objects, select Teradata > Show DDL
    • For Aster objects, select Aster > Display DDL.
    If you are not in the Query Development perspective, which has an SQL Editor view by default, a message appears asking if you want to switch to it. If you Click No, an SQL Editor view opens in the current perspective to show the DDL. The CREATE statement that defines the object displays in the SQL Editor.