15.00 - SHOW and the IN XML Option - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

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

SHOW and the IN XML Option

When you submit a SHOW request with the IN XML option, Teradata Database returns the definitions of all the objects referenced by the specified DML request in XML format.

There are some exclusions to the database objects reported. The following set of bullets lists the database objects that Teradata Database does not support for the IN XML option.

  • CAST
  • CONSTRAINT
  • ERROR TABLE
  • FUNCTION
  • MACRO
  • METHOD
  • PROCEDURE
  • SPECIFIC FUNCTION
  • TRIGGER
  • TYPE
  • When you submit a SHOW IN XML request on an unsupported database object type, Teradata Database aborts the request and returns an error.

    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.

    Teradata Database 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.

    Note: Teradata Database returns the response to any SHOW IN XML request in a single result set in most cases. For multi-statement requests that contain multiple SHOW IN XML statements, Teradata Database returns 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 Teradata Database to recreate the same database object.