Identifier Compliance to ANSI Standards

To be compliant with entry-level ANSI SQL, identifiers cannot begin with a pound sign (#), have more than 18 characters, or contain lowercase letters. SAP ASE supports delimited identifiers for table, view, and column names which can be used to avoid certain restrictions on object names.

Delimited identifiers are object names enclosed in double quotation marks. Use the set quoted_identifier option to recognize delimited identifiers. When this option is on, all characters enclosed in double quotes are treated as identifiers. Because this behavior is incompatible with many existing applications, the default setting for this option is off.