17.10 - Rules for Object Naming - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Advanced SQL Engine International Character Set Support

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
User Guide
Publication ID
B035-1125-171K
Language
English (United States)

The following summarizes object naming rules:

Parameter Description
Object name length A maximum of 128 characters when expressed in UNICODE normalization form D.

The DBS Control NameValidationRule field can be set to apply additional character restrictions.

Characters allowed in object names not enclosed in quotation marks An object name not enclosed in quotation marks must be composed of an identifier-start character followed by a sequence of identifier-start or identifier extend characters, up to the maximum object name length limit.
Characters in object names not enclosed in quotation marks must also be in the session character set.
Identifier start characters must be contained in the session character set and belong to one of the following Unicode General Category classes:
  • Upper-case letters [Lu]
  • Lower-case letters [Ll]
  • Title-case letters [Lt]
  • Modifier letters [Lm]
  • Other letters ([Lo]
  • Letter numbers [Nl]
...Or be one of the following characters:
  • NUMBER SIGN (U+0023)
  • DOLLAR SIGN (U+0024)
  • LOW LINE (U+005F)
  • INVERTED EXCLAMATION MARK (U+001A)
  • OVERLINE (U+203E)
  • EURO SIGN (U+20AC)
  • KATAKANA-HIRAGANA VOICED SOUND MARK (U+309B)
  • KATAKANA-HIRAGANA SEMI-VOICED SOUND MARK (U+309B)
  • FULLWIDTH NUMBER SIGN (U+FF03)
  • FULLWIDTH DOLLAR SIGN (U+FF04)
  • FULLWIDTH LOW LINE (U+FF3F)
Identifier-extender characters must be in the session character set and belong to one of the following Unicode General Category classes:
  • Non-spacing marks [Mn]
  • Spacing combing marks [Mc]
  • Decimal numbers [Nd]
  • Connector punctuations [Pc]
  • Formatting codes [Cf]
The MIDDLE DOT character is also a valid identifier-extender character.
Characters allowed only in object names that are enclosed in quotation marks A quoted string is required for object names that:
  • Have an identifier-extender character as the first character.
  • Include the white space character, SPACE (U+022)
  • Are Teradata keywords
In addition, object names that contain any character from the following classes must be enclosed in quotation marks, unless the character explicitly appears in the list of allowed characters:
  • Other, Control [Cc]
  • Other, Not Assigned [Cn]
    No characters in this category appear in UNICODE character repertoire.
  • Other, Private Use [Co]
  • Other, Surrogate [Cs]
  • Letter, Cased [LC]
  • Mark, Enclosing [Me]
  • Number, Other [No]
  • Punctuation, Dash [Pd]
  • Punctuation, Close [Pe]
  • Punctuation, Final quote [Pf] (may behave like Ps or Pe depending on usage)
  • Punctuation, Initial quote [Pi] (may behave like Ps or Pe depending on usage)
  • Punctuation, Other [Po]
  • Punctuation, Open [Ps]
  • Symbol, Currency [Sc]
  • Symbol, Modifier [Sk]
  • Symbol, Math [Sm]
  • Symbol, Other [So]
  • Separator, Line [Zl]
  • Separator, Paragraph [Zp]
  • Separator, Space [Zs]
When used to enclose an object name, the beginning and ending quotation marks must be represented as a sequence of two QUOTATION MARK characters (U+0022). Each set of two quotation marks is counted as one character when calculating the name size limit.
Disallowed characters The following characters cannot appear in an object name:
  • NULL (U+0000)
  • SUBSTITUTE character (U+001A)
  • REPLACEMENT CHARACTER (U+FFFD)
  • Compatibility ideographs (U+FA6C, U+FA6F, U+FAD0, FAD1, FAD5, FAD6, and FAD7)
The setting of the NameValidationRule field may define additional character restrictions. For more information, see Teradata Vantage™ - Database Utilities, B035-1102.
Other considerations These additional restrictions apply:
  • An object name consisting entirely of white spaces is not allowed.
  • A trailing white space is not considered part of an object name
  • You can use the NameValidationRule field to restrict object name allowable characters to a subset of those normally allowed with object naming. For more information, see Teradata Vantage™ - Database Utilities, B035-1102.