Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners

ASA Code Factory online Help

  Return to chapter overview  

SQL Anywhere identifiers

Identifiers have a maximum length of 128 bytes. They must be enclosed in double quotes or square brackets if any of the following conditions are true:

 

The identifier contains spaces.
The first character of the identifier is not an alphabetic character (as defined below).
The identifier contains a reserved word.
The identifier contains characters other than alphabetic characters and digits.

 

Alphabetic characters include the alphabet, as well as the underscore character (_), at sign (@), number sign (#), and dollar sign ($). The database collation sequence dictates which characters are considered alphabetic or digit characters.

The following characters are not permitted in identifiers:

 

Double quotes
Control characters (any character less than 0x20)
Double backslashes

 

You can use a single backslash in an identifier only if it is used as an escape character.



  Return to chapter overview