Restricted Words |Reserved Words | Teradata Vantage - 17.00 - Teradata Vantage Restricted Words - Teradata Database

Teradata Vantage™ - Advanced SQL Engine Release Summary

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
September 2020
category
Release Notes
featnum
B035-1098-170K

This section lists new Teradata reserved and nonreserved words, as well as ANSI SQL:2011 reserved and nonreserved words introduced in Teradata Vantage Advanced SQL Engine Releases 17.xx.

For information on how to generate a complete list of restricted words, see Teradata Vantage™ - SQL Fundamentals, B035-1141.

Teradata Vantage Reserved Words

Teradata Vantage reserved words cannot be used as identifiers to name host variables, correlations, local variables in SQL stored procedures, objects (such as databases, tables, columns, or stored procedures), or parameters, such as macro or stored procedure parameters, because Teradata Vantage already uses the word and might misinterpret it.

Teradata Vantage Nonreserved Words

Teradata Vantage nonreserved keywords are permitted as identifiers but are discouraged because they may in the future be used as reserved keywords.

Teradata Vantage Future Reserved Words

Teradata Vantage future reserved words are words reserved for future Vantage use, and cannot be used as identifiers.

Teradata Parallel Transporter Restricted Words

For a list of Teradata Parallel Transporter (TPT) restricted words, see Teradata® Parallel Transporter User Guide, B035-2445.

ANSI SQL:2011 Reserved Words

The danger in using an ANSI reserved word that is not currently a Teradata reserved word is that it may in the future become a Teradata reserved word if Teradata implements the ANSI feature that uses it.

ANSI SQL:2011 Nonreserved Words

The danger in using an ANSI nonreserved word is that it may in the future become a Teradata reserved word if Teradata implements the ANSI feature that uses it.

New Restricted Words

Word Teradata Vantage Status ANSI SQL-2011 Status
Reserved Future Nonreserved Reserved Nonreserved
TD_ROWSIZE 17.00        
TD_ROWREVISION 17.00