The following summarizes object naming rules:
|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:
...Or be one of the following characters:
Identifier-extender characters must be in the session character set and belong to one of the following Unicode General Category classes:
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:
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:
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:
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: