15.00 - About SHOW Statements - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Teradata Database
Release Number
Content Type
Programming Reference
Publication ID
English (United States)

About SHOW Statements

Using SHOW Statements

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.