16.20 - Applications of SHOW TABLE IN XML and SHOW HASH INDEX IN XML - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Detailed Topics

Teradata Database
Teradata Vantage NewSQL Engine
Release Number
March 2019
Content Type
Programming Reference
Publication ID
English (United States)

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