Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » SQL Language Elements

Reserved words Next Page

Identifiers


Identifiers are names of objects in the database, such as user IDs, tables, and columns.

Remarks

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:

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:

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

If the quoted_identifier database option is set to Off, double quotes are used to delimit SQL strings and cannot be used for identifiers. However, you can always use square brackets to delimit identifiers, regardless of the setting of quoted_identifier. The default setting for the quoted_identifier option is to Off for Open Client and jConnect connections; otherwise the default is On.

See also
Examples

The following are all valid identifiers.

Surname
"Surname"
[Surname]
SomeBigName
"Client Number"