SHOW and the IN XML Option - Analytics Database - Teradata Vantage

SQL Data Definition Language Detailed Topics

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-07-11
dita:mapPath
vuk1628111288877.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
B035-1184
lifecycle
latest
Product Category
Teradata Vantage™

You can submit a SHOW request with the IN XML option to return the definitions of all the objects referenced by the specified DML request in XML format.

You cannot specify the IN XML option for the following database objects:
  • CAST
  • CONSTRAINT
  • ERROR TABLE
  • FUNCTION
  • MACRO
  • METHOD
  • PROCEDURE
  • SPECIFIC FUNCTION
  • TRIGGER
  • TYPE

The encoding of object names, SQL text, and literal character values is controlled by the default character for the session in which a SHOW IN XML request is executed.

Vantage sorts the objects in a topological order where objects in the lower order do not depend on objects in the higher order.

While Teradata provides the XML schemas required to interpret the XML files produced by the IN XML option, you must use a tool with a standard XML parser to interpret them.

Vantage returns the response to any SHOW IN XML request in a single result set in most cases. For multistatement requests that contain multiple SHOW IN XML statements, Vantagereturns multiple result sets, with each result set containing one XML document that corresponds to the matching request.

Unlike the case for ordinary SHOW requests, you cannot submit the output of a SHOW IN XML request to Vantage to recreate the same database object.