.ALL Operator - Teradata Database

SQL Data Manipulation Language

Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-10-06
dita:id
B035-1146
lifecycle
previous
Product Category
Teradata® Database

For structured UDTs only, .ALL specifies that the individual attribute values for a specified table or column name are to be returned.

 

Syntax Element …

Specifies …

table_name

the name of a table for which all the attributes of all its structured UDT columns are to be returned.

column_name

the name of a structured UDT column for which all its attributes are to be returned.

.ALL

that all attributes for the specified UDT column or for all structured UDT columns in the specified table are to be returned in the results of the expression list.