The following statement changes the setting of the quoted_identifier option to On:

SET quoted_identifier On;

The following statement changes the setting of the quoted_identifier option to Off:

SET quoted_identifier Off;

You can choose to use either the SQL/2008 or the default Transact-SQL convention in SQL Anywhere as long as the quoted_identifier option is set to the same value in each DBMS.

If you choose to operate with the quoted_identifier option On (the default setting), then the following statements involving the SQL keyword user are valid for both DBMSs.

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

If you choose to operate with the quoted_identifier option off then the following statement is valid for both DBMSs. In the following example, Chin is a string and not an identifier.

SELECT *
FROM Employees
WHERE Surname = "Chin"
go

• quoted_identifier option
• Reserved words