The quoted_identifier Option

Both Adaptive Server and SAP Sybase IQ provide a quoted_identifier option that allows the interpretation of delimited strings to be changed. By default, the quoted_identifier option is set to OFF in Adaptive Server, and to ON in SAP Sybase IQ.

You cannot use SQL reserved words as identifiers if the quoted_identifier option is off.

Although the Transact-SQL SET statement is not supported for most Adaptive Server connection options, SET is supported for the quoted_identifier option.

The following statement in either SAP Sybase IQ or Adaptive Server changes the setting of the quoted_identifier option to ON:

SET quoted_identifier ON

With the quoted_identifier option set to ON, Adaptive Server allows table, view, and column names to be delimited by quotes. Other object names cannot be delimited in Adaptive Server.

The following statement in SAP Sybase IQ or Adaptive Server changes the setting of the quoted_identifier option to OFF:

SET quoted_identifier OFF

You can choose to use either the SQL92 or the default Transact-SQL convention in both Adaptive Server and SAP Sybase IQ as long as the quoted_identifier option is set to the same value in each DBMS.

Examples

If you operate with the quoted_identifier option ON (the default SAP Sybase IQ setting), the following statements involving the SQL keyword user are valid for both types of DBMS.

CREATE TABLE "user" (
	col1 char(5)
) ;
INSERT "user" ( col1 )
VALUES ( 'abcde' ) ;

If you operate with the quoted_identifier option OFF (the default Adaptive Server setting), the following statements are valid for both types of DBMS.

SELECT *
FROM Employees
WHERE Surname = "Chin"