16.00 - Showing DDL Statements - Teradata Studio

Teradata Studio User Guide

prodname
Teradata Studio
vrm_release
16.00
created_date
March 2017
category
User Guide
featnum
B035-2041-126K
  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.