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