The following sections describe SQL attribute functions.
Attribute functions return descriptive information about their operand. Except for the DEFAULT function, the operand need not be a column reference; it can be a general expression that is not evaluated mathematically.
When an attribute function is used in a request, the response returns one row for every data row that meets the search condition.
Some of these functions are extensions to ANSI SQL.
For a list of data type attributes, see “Data Type Phrases” in Teradata Vantage™ Data Types and Literals, B035-1143.
Each attribute function is described individually in the following topics.