Restricted Words Overview | SQL Fundamentals | Teradata Vantage - 17.10 - Restricted Words - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Fundamentals

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

Teradata and ANSI/ISO SQL standards restrict the use of certain words as identifiers because those words may be incorrectly interpreted as SQL keywords. Restricted words should not be used as database object names or as parameters in application programs that interface with the database. The categories of restricted words are:

Category Description
Reserved words These words are used as keywords by Teradata or ANSI/ISO SQL. They cannot be used as identifiers to name database objects, such as databases, tables, columns, or stored procedures. They also must not be used as macro or stored procedure parameters or local variables, host variables, or correlation names. Reserved words can be reserved by Teradata, by the ANSI/ISO SQL standard, or by both.
Future reserved words These words are likely to be used as Teradata keywords in the future. Like reserved words, future reserved words cannot be used as identifiers.
Nonreserved words

These words may become keywords in the future.

Teradata does not recommend using nonreserved words as identifiers if these words are reserved words in the ANSI standard. These words may become reserved words in the future.

Teradata Parallel Transporter (Teradata PT) has a different set of restricted words.

You can use the SQLRestrictedWords view and SQLRestrictedWords_TBF function to see or query the restricted words in the current or previous database releases.

Related Information

For a list of Teradata PT restricted words, see Teradata® Parallel Transporter Reference, B035-2436.