15.00 - TITLE - Teradata Database

Teradata Database SQL Functions, Operators, Expressions, and Predicates

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1145-015K
Language
English (United States)

TITLE

Purpose  

Returns the title of an expression as it would appear in the heading for displayed or printed results.

Syntax  

where:

 

Syntax element …

Specifies …

expression

the expression for which the title is to be returned.

ANSI Compliance

This is a Teradata extension to the ANSI SQL:2011 standard.

Result Type and Attributes

TITLE returns a CHAR(n) character string of up to 60 characters. The result type, character set, format, and title for TITLE appear in the following table.

 

Data Type

Format

Title

CHAR(n) CHARACTER SET UNICODE

X(60)

Title(named_expression)

For information on data type default formats, see “Data Type Formats and Format Phrases” in SQL Data Types and Literals.

Usage Notes  

Use the TITLE phrase to change the heading for displayed or printed results that is different from the column name, which is the default heading.

For more information, see SQL Data Types and Literals.

Example  

The following statement requests the title of the Salary column in the Employee table.

   SELECT TITLE(Employee.Salary); 

The result is the following.

   Title(Salary)   
   ------------------------------------------------------------
   Salary