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.