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

SQL Anywhere 17 » SQL Anywhere Server - Database Administration » Database configuration » Database options » Alphabetical list of database options

quote_all_identifiers option [SQL Remote]

Controls whether SQL statements being replicated by SQL Remote should use quoted identifiers.

Allowed values

On, Off

Default

Off

Scope
  PUBLIC role For current user For other users
Allowed to set permanently? Yes, with SET ANY USER DEFINED OPTION Yes Yes, with SET ANY USER DEFINED OPTION
Allowed to set temporarily? No No No
Remarks

When this option is Off, dbremote quotes identifiers that require quotes by SQL Anywhere.

When the option is On, all identifiers are quoted.