.ALL Operator and Structured UDTs - Teradata Database

If a column has a structured UDT data type, then the values of its individual attributes are returned when you specify the .ALL option.

If you specify the .ALL operator using either of these syntaxes, but there is no structured data type column in the specified table set, Teradata Database disregards the specification.

*.ALL

table_name.*.ALL

If you specify this syntax, but the specified column does not have a structured UDT type, the specification is disregarded:

     column_name.ALL

See “Example 1: Using the .ALL Operator With Structured UDTs” on page 73.