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