Applications of SHOW TABLE IN XML and SHOW HASH INDEX IN XML
The IN XML option for SHOW TABLE and SHOW HASH INDEX enables Teradata Tools and Utilities
applications and third party tools to retrieve and display table and hash index definitions
and their properties in XML format.
You can also export the definitions of tables or hash indexes from Teradata Database
in XML format. This enables the following applications.
Displaying and modifying table and hash index definitions using a GUI that does not
need to be able to understand and write DDL statements.
Offline analysis of SQL workloads that require detailed definitions of the database
objects being referenced.
Easily moving tables and hash indexes from one version of Teradata Database to another
using a Teradata Tools and Utilities program like Teradata Data Mover that can parse
XML object definitions and produce DDL statements to apply on the target database
server, with the mapping of database features to database releases available on the