Newname in SELECT Statement

ODBC Driver for Teradata® User Guide

brand
Teradata Tools and Utilities
prodname
ODBC Driver for Teradata
vrm_release
16.20
category
User Guide
featnum
B035-2526-108K

In the select-list in SELECT statements, each expression can be followed by [AS] newname, where the AS keyword is optional, and newname is a name-title for the column. The newname can optionally be enclosed in double quotes (as can all names). For more information, see Teradata ODBC Specific Comparison Operators (deprecated in 14.10).

This syntax is compatible with X/OPEN SQL (X/Open requires the AS keyword), ANSI SQL 1992, Microsoft Access SQL, SyBase/SQL Server, and several others.

In addition, for better SQL Server compatibility, the newname can be enclosed in single quotes instead of double quotes, although the use of single quotes should be discouraged since it is not ANSI-compliant. We recommend that you do not use Teradata TITLE or NAMED clauses, and instead use this syntax when possible.