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

SQL Data Definition Language Detailed Topics

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-07-11
dita:mapPath
vuk1628111288877.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
B035-1184
lifecycle
latest
Product Category
Teradata Vantage™

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.