15.00 - SQLRestrictedWords View - Teradata Database

Teradata Database SQL Fundamentals

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1141-015K

SQLRestrictedWords View

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

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
  • ANSI_restricted

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

  • R: an ANSI reserved word
  • N: an ANSI nonreserved word
  • T: a word that is neither reserved nor nonreserved by current ANSI standards, but that is restricted by Teradata
  • Usage Notes

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

    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
    ------------------------------  --------  ---------------
    ABS                             R         R
    ACCOUNT                         R         T
    ACCESS_LOCK                     R         T
    ABORTSESSION                    R         T
    ABORT                           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.

    Note: 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 
    ...