TABLE 15. Allowed Characters in Identifiers
Database
|
|
Identifiers Must Begin with
|
Subsequent Characters
|
Delimited Identifiers
|
Oracle
|
an alphabetical character
|
alphanumeric characters, _, $ and #
|
Supported
|
IBM DB2
|
Unix, Windows
|
an alphabetical character, $, # and @
|
alphanumeric characters, _, $, # and @
|
Supported
|
OS/390
|
an alphabetical character
|
alphanumeric characters and _
|
Supported
|
AS/400
|
an alphabetical character
|
alphanumeric characters and _
|
Supported
|
Microsoft SQL Server
|
an alphabetical character, _ , @ and #
|
alphanumeric characters, _, $, # and @
|
Supported
|
Sybase
|
ASE
|
an alphabetical character and _
|
alphanumeric characters, _, $, # and @
|
Supported
|
ASA
|
an alphabetical character and _
|
alphanumeric characters, _, $, # and @
|
Supported
|
MySQL
|
prior to 3.23.6
|
alphanumeric characters, _ and $
|
alphanumeric characters, _ and $
|
Not supported
|
3.23.6 or later
|
characters that are allowed in a file name, except / or .
|
characters that are allowed in a file name, except / or .
|
Supported
|
Pervasive.SQL
|
an alphabetical character
|
alphanumeric characters and _
|
Supported
|