15.10 - SHOW request - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

Purpose

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.

Syntax