Usage and Limitations | SHOW Statement | Teradata Vantage - Limitations in the Application of SHOW JOIN INDEX IN XML and SHOW VIEW 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 reports the SQL DDL, but not all of the definition constructs for join indexes and views, so it is not possible to decompose and reconstruct their definitions from their reported XML format definitions.

This means that you cannot use Teradata Tools and Utilities applications or third-party tools to retrieve join index or view definitions and their properties in XML format, nor can you export the definitions of those objects from the database in XML format.

Despite this, the XML text for join index definitions is helpful because it includes the following useful information.
  • The names and data types of the columns in the join index or view definition in XML format.

    You can then create global temporary or volatile tables to record the XML text view or join index definition data.

  • A list of all of the referenced database objects in the join index or view definition.

    This information is useful for validating that the base tables referenced in the join index or view definition are available, because Vantage only makes a semantic check when the object is referenced at run time.