16.20 - Limitations in the Application of SHOW JOIN INDEX IN XML and SHOW VIEW IN XML - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Detailed Topics

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1184-162K
Language
English (United States)

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 Teradata 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 Teradata Database only makes a semantic check when the object is referenced at run time.