Using SHOW Statement | Teradata Vantage - 17.10 - Using SHOW Statements - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Detailed Topics

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
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_object statement.

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.