The following summarizes object naming rules:
| Parameter | Description |
|---|---|
| Object name length | A maximum of 128 characters when expressed in UNICODE normalization form D. If you want to apply additional character restrictions, contact Teradata Support. |
| Characters allowed in object names not enclosed in quotation marks | This is the situation where just quotes are useful. 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
|
| Other considerations | These additional restrictions apply:
|