15.00 - About SHOW Statements - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1184-015K

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.