15.10 - SHOW request - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

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


Displays the DDL for all database objects referenced by a specified DML request.

You can return the report in XML format.

For information on displaying query logging information, see SHOW QUERY LOGGING.

Required Privileges

You must have either of the following privileges to execute a SHOW or SHOW IN XML request.

  • The privileges necessary to perform the specified DML request
  • Any privilege on the database objects to show.

Use the SHOW privilege to enable a user to perform HELP or SHOW requests only against the specified DML request.