16.20 - Report Structure - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Detailed Topics

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1184-162K
Language
English (United States)

The SHOW report lists the DML_statement DDL definitions in order of dependencies, first listing the definitions of independent objects and then listing dependent objects.

The rank ordering of the DDL definitions in the report is as follows:

  1. Base tables
  2. Referenced (parent) tables of base tables
  3. Error tables
  4. Views
  5. Macros
  6. Triggers
  7. Join and hash indexes
  8. UDTs