Object names are always stored in the data dictionary in UNICODE. Specification of object names is subject to these character usage rules:
For information on... |
See... |
Detailed considerations for object naming, including strategies for using the DBS Control fields that determine object naming rules |
SQL Fundamentals |
Setting DBS Control object naming control. |
Utilities |
The system determines the characters available for use in object names based on the rules determined by the settings of DBS Control object naming control fields.
Object naming controls determine several naming parameters including available character repertoire and name length.
Optional name validation rules can impose additional character restrictions.
Note: Changing object naming control settings only affects objects that are created after the setting change.
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 used 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. Note: 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: Note: 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: Note: No characters in this category appear in UNICODE character repertoire. Note: 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: Note: The setting of the NameValidationRule field may define additional character restrictions. See Utilities. |
Other considerations |
These additional restrictions apply: |
All object names are stored in the data dictionary in UNICODE. Teradata provides a file, UOBJNEXT.txt, which lists the UNICODE characters valid for object names. The file is available on the Teradata User Documentation CD and at http://www.info.teradata.com.
Use of these UNICODE characters in object names is subject to limitations imposed by:
Object names and literals returned by HELP and SHOW statements, and by requests that specify the EXPLAIN modifier, may not be sharable among clients with differing client (session) character sets.
For details, see SQL Data Definition Language Syntax and Examples.
Related Information
For information on... |
See... |
Using the SHOW, HELP, and EXPLAIN commands |
SQL Data Definition Language Syntax and Examples |
UNICODE delimited literals and identifiers |
SQL Fundamentals |