17.10 - Applications of SHOW TABLE IN XML and SHOW HASH INDEX IN XML - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Detailed Topics

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1184-171K
Language
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 Vantage 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 database version 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.