16.20 - Using SHOW Statements - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Detailed Topics

Teradata Database
Teradata Vantage NewSQL Engine
Release Number
March 2019
Content Type
Programming Reference
Publication ID
English (United States)

SHOW statements return the result of the last data definition statement performed against the named database object in the form of a CREATE database_object or ALTER database_objectstatement.

These statements are particularly useful for application developers who need to develop exact replicas of existing tables, views, triggers, hash and join indexes, stored procedures, user-defined functions, or macros for purposes of testing new software.

Some SHOW statements optionally return database object definition SQL text in XML format.