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 must 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 | Keywords of Teradata SQL, ANSI/ISO SQL, or both. Cannot be used as identifiers. |
| Future reserved words | Reseved for use as Teradata keywords. Cannot be used as identifiers. |
| Nonreserved words | May become reserved words. Not recommended for uses as identifiers. |
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.