15.10 - SHOW Options - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K
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.