SHOW TYPE - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Detailed Topics

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-24
dita:mapPath
jpx1556733107962.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1184
lifecycle
previous
Product Category
Teradata Vantage™

This statement reports all the user-submitted DDL statements used to create the specified type and define its behavior except CREATE CAST, not just the create text for the specified UDT. To report CREATE CAST DDL, you must use the SHOW CAST statement.

For ARRAY and VARRAY types, SHOW TYPE reports the most recent SQL create text for the ARRAY type in standard Teradata syntax, using the ARRAY keyword. The ordering and transform functionality for the ARRAY type are not be reported, because it is system-generated and there is no create text to return.

The report includes information about the following related DDL statements for the type and its supporting semantics including the create text for the following definitions:

  • CREATE TYPE
  • CREATE ORDERING
  • CREATE TRANSFORM

SHOW TYPE does not return the create text for any of the system-generated orderings, or transforms for a distinct type because no CREATE ORDERING or CREATE TRANSFORM statements were performed to create them. As a result, there is no create text that can be reported for system-generated casts, orderings, or transforms.

Because the specification of user-defined casts is optional, there might not be a cast definition for a given UDT. In this case, Teradata Database returns a “No rows returned” message to the requestor indicating that no casts have been defined for the specified UDT.