SHOW request Syntax Elements - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905
IN XML
Return the report in XML format.
The XML schema for the output produced by this option is located in SchemaFiles.zip under attachments in the left pane.
QUALIFIED
Any view DDL returned is to be qualified by the appropriate database and table names. This qualified text is taken from the DBC.TVM.CreateText column.
All qualified objects in the report are enclosed within QUOTATION MARK characters.
If you do not specify QUALIFIED, then any returned view DDL is taken from the DBC.TVM.RequestText column and is not qualified by the names of the appropriate database and table names.
DML_request
An SQL DML request for which the full text of the DDL for all referenced database objects is to be returned.
System-defined join index definitions on a temporal table are not returned by a SHOW DML request. The base table definition text seen in the SHOW TABLE output on which the system-defined join index is created returns the temporal constraints implemented as system-defined single-table join indexes, and only when this CREATE TABLE SQL text is issued to the database that the system-defined join indexes, if any, are created.