15.00 - Applications of SHOW TABLE IN XML and SHOW HASH INDEX IN XML - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

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

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