16.10 - SQLRestrictedWords View - Teradata Database

Teradata Database SQL Fundamentals

Product
Teradata Database
Release Number
16.10
Release Date
June 2017
Content Type
Programming Reference
Publication ID
B035-1141-161K
Language
English (United States)

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

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."