Naming Columns and Expressions | Date Types and Literals | Teradata Vantage - 17.10 - Naming Columns and Expressions - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Data Types and Literals

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

Each column in a SELECT result has a name that is derived from the list of specified column names (expressions) that generated the data. The name is typically the column name from which the data came.

For example, the columns in the result

SELECT EmpNo, Name
FROM Employee;

are labeled EmpNo and Name by default.

In some cases, it is necessary to associate a column name that is different from the default column name with a result. Vantage provides two ways to name a column.

This phrase for naming … Is …
NAMED a Teradata extension to the ANSI SQL:2011 standard.
AS ANSI SQL:2011 compliant.