Contents Index Reserved words Strings

ASA SQL Reference
  SQL Language Elements

Identifiers


Function 

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

Description 

Identifiers need to 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.

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 JDBC connections; otherwise the default is ON.

You can represent a quotation mark inside an identifier by following it with another quotation mark.

Identifiers have a maximum length of 128 bytes.

See also 

For a complete list of the reserved words, see Reserved words.

For information about the QUOTED_IDENTIFIER option, see QUOTED_IDENTIFIER option [compatibility].

Examples 

The following are all valid identifiers.

Surname
"Surname"
[Surname]
SomeBigName
"Client Number"
"With one double quotation "" mark"

Contents Index Reserved words Strings