Naming Columns and Expressions | Date Types & Literals | VantageCloud Lake - Naming Columns and Expressions - Teradata Vantage

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.

You may have to associate a column name that is different from the default column name with a result. Vantage provides two ways to name a column.