16.20 - SQLRestrictedWords View - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Fundamentals

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-02
dita:mapPath
zce1519094756513.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

The SQLRestrictedWords view lists all restricted words for the current release of Teradata Database.

SQLRestrictedWords is created in the SYSLIB database by the DIPDEM script, which is run automatically by the DIP utility when Teradata Database is installed.

The view contains these columns:

Column Name Description
restricted_word The restricted word.
category These words are likely to be used as Teradata Database, keywords in the future. Like reserved words, future reserved words cannot be used as identifiers.
ANSI_restricted

One of the following characters that represents the category of the Teradata restricted word:

  • R: a Teradata reserved word
  • F: a Teradata future reserved word
  • N: a Teradata nonreserved word

Usage Notes

Queries of SQLRestrictedWords are case specific.

Example: Getting the Restricted Words for the Current Release

This query returns the restricted words for the current Teradata 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
...                             ...       ...

Example: Getting Nonreserved Words that are ANSI Reserved Words

The following query returns the nonreserved words for the current Teradata Database release that are ANSI reserved words. A portion of the output is shown below.

This result is useful because Teradata does not recommend using Teradata Database nonreserved words as identifiers if these words are reserved words in the ANSI standard. These words may become Teradata Database reserved words in the future.
SELECT restricted_word
FROM SYSLIB.SQLRestrictedWords
WHERE category=’N’ AND ANSI_restricted=’R’;

restricted_word
------------------------------
ALLOCATE
CALLED
CONDITION
GLOBAL
MEMBER
...

Related Topics

To retrieve or query Teradata SQL restricted words from Teradata Database releases other than the current release, see SQLRestrictedWords_TBF Function.