NexusDB V3 Manual
Regular Identifiers
|
  
|
NexusDB Manual V3 > Management Tools > The Enterprise Manager > Creating and Restructuring Tables
|
NexusDB Engine only allows code page neutral ANSI characters in identifiers (table names, field names, ...), that is characters having the same ordinal value regardless of a code page. The following table shows the valid characters that can be used in regular identifiers:
Character
|
Code
|
Symbol
|
Exclamation mark
|
#33
|
!
|
Pound sign
|
#35
|
#
|
Dollar sign
|
#36
|
$
|
Percent
|
#37
|
%
|
Ampersand
|
#38
|
&
|
Left parenthesis
|
#40
|
(
|
Right parenthesis
|
#41
|
)
|
Plus sign
|
#43
|
+
|
Minus sign
|
#45
|
-
|
Digit
|
#48..#57
|
0..9
|
At sign
|
#64
|
@
|
Upper case letter
|
#65..#90
|
A..Z
|
Left bracket
|
#91
|
[
|
Right bracket
|
#93
|
]
|
Circumflex
|
#94
|
^
|
Underscore
|
#95
|
_
|
Lower case letter
|
#97..#122
|
a..z
|
Left brace
|
#123
|
{
|
Right brace
|
#125
|
}
|
Tilde
|
#126
|
~
|
•
|
A regular identifier is an unquoted string of characters.
|
§
|
Regular identifiers cannot contain spaces.
|
§
|
Regular identifiers cannot begin with a decimal digit.
|
§
|
Regular identifiers are case-insensitive.
|
§
|
The maximum length of regular identifiers is 128 characters.
|
|
© Nexus Database Systems Pty Ltd.
