17.00 - SHOW Options - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Release Date
September 2020
Content Type
Programming Reference
Publication ID
B035-1144-170K
Language
English (United States)
IN XML
Returns the report in XML format.

This option only applies to SHOW HASH INDEX, SHOW JOIN INDEX, SHOW TABLE, and SHOW VIEW. You can also report on error tables by using the SHOW IN XML TABLE error_table_name syntax.

For information on the usage limitations of the output of the IN XML option for join indexes and views, see join_index_name or view_name, respectively, later in this table.

The XML schema for the output produced by this option is maintained in:

http://schemas.teradata.com/queryplan/queryplan.xsd
database_name
The name of the containing database for the object.

For UDTs, methods, and UDFs related to UDTs, this is always SYSUDTLIB.

user_name
The name of the containing user for the object.

For UDTs, methods, and UDFs related to UDTs, this is always SYSUDTLIB.