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.
ANSI Compliance
This statement is a Teradata extension to the ANSI SQL:2011 standard.
Required Privileges
You must have 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.
The SHOW privilege to enables you to perform HELP or SHOW requests for the specified DML request.