Restricted Words |Reserved Words | Teradata Vantage - 17.10 - Teradata Vantage Restricted Words - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Advanced SQL Engine Release Summary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Release Notes
Publication ID
B035-1098-171K
Language
English (United States)

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
FUNCTIONDESCRIPTOR 17.10        
TD_ROWSIZE 17.00        
TD_ROWREVISION 17.00        

Getting the Restricted Words for the Current Release

This query returns the restricted words for the current database release. Because it returns all columns from the view, it includes the Teradata and ANSI categories for the words.

A portion of the output is shown below.

SELECT * FROM SYSLIB.SQLRestrictedWords;

restricted_word                 category  ANSI_restricted
------------------------------  --------  ---------------
ABORT                           R         T
ABORTSESSION                    R         T
ABS                             R         R
ACCESS_LOCK                     R         T
...                             ...       ...

For more information, see Teradata Vantage™ - SQL Fundamentals.