- 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.