Newname in SELECT Statement - ODBC Driver for Teradata

ODBC Driver for Teradata® User Guide

Product
ODBC Driver for Teradata
Release Number
16.20
Published
August 2020
Language
English (United States)
Last Update
2020-08-25
dita:mapPath
fxv1527114222338.ditamap
dita:ditavalPath
Audience_PDF_product_legacy_odbc_include.ditaval
dita:id
B035-2526
lifecycle
previous
Product Category
Teradata Tools and Utilities

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. Teradata recommends that you do not use Teradata TITLE or NAMED clauses, and instead use this syntax when possible.