SHOW TYPE - Analytics Database - Teradata Vantage

SQL Data Definition Language Detailed Topics

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-07-11
dita:mapPath
vuk1628111288877.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
B035-1184
lifecycle
latest
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, the system returns a “No rows returned” message to the requestor indicating that no casts have been defined for the specified UDT.