16.10 - Naming Columns and Expressions - Teradata Database

Teradata Database SQL Data Types and Literals

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Programming Reference
featnum
B035-1143-161K

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. Teradata Database 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.