- The name of the view whose most recent SQL create text is to be reported. There is an upper limit of 12,500 characters that SHOW VIEW can display.
A SHOW VIEW IN XML request does not report all of the definition constructs for views, so it is not possible to decompose and reconstruct their definitions from their reported XML format definitions.
Despite this, the XML text for view definitions is helpful because it includes the following useful information.
- The names and data types of the columns in the view definition.
- A list of all of the referenced database objects in the view definition.
For further information, see Teradata Vantage™ - SQL Data Definition Language Detailed Topics , B035-1184 .