SHOW request | SHOW Statement | Teradata Vantage - 17.10 - Report Structure - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Detailed Topics

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1184-171K
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