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

SQL Anywhere 17 » UltraLite - Database Management and Developer Guide » UltraLite SQL reference » UltraLite SQL language elements

Identifiers in UltraLite

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

Identifiers have a maximum length of 128 bytes and are composed from alphabetic characters and digits, as well as the underscore character (_) and at sign (@). Leading digits are allowed but the identifier must be quoted. Other special characters are allowed but the identifier must be quoted. The database collation sequence dictates which characters are considered alphabetic or digit characters.

Double quotes (") are not permitted in identifiers:

Quoting identifiers

If any of the following conditions are true, then always enclose an identifier in double quotes:

  • The identifier contains leading, trailing, or embedded spaces.

  • The first character of the identifier is not an alphabetic character, the underscore character (_), or at sign (@). For example, the first character is a digit.

  • The identifier contains characters other than the alphabetic characters, digits, underscore character (_), and at sign (@).

  • The identifier is a reserved word.

For compatibility with other database management systems, it is recommended that you avoid the use of special characters in identifier names, including but not limited to any of the following:

  • Leading or trailing whitespace

  • Leading single quote

  • Semicolons