Contents Index QUOTE_ALL_IDENTIFIERS option [replication] READ_PAST_DELETED option [database]

ASA Database Administration Guide
  Database Options
    Alphabetical list of options

QUOTED_IDENTIFIER option [compatibility]


Function 

Controls the interpretation of strings that are enclosed in double quotes.

Allowed values 

ON, OFF

Default 

ON

OFF for Open Client and JDBC connections

Description 

This option controls whether strings that are enclosed in double quotes are interpreted as identifiers (ON) or as literal strings (OFF). The QUOTED_IDENTIFIER option is included for Transact-SQL compatibility.

Note that Interactive SQL automatically executes the equivalent of

SET TEMPORARY OPTION QUOTED_IDENTIFIER = ON

when it connects to a database. TEMPORARY options apply only to the current connection, and last only until the connection is closed.

For more information, see Setting options for Transact-SQL compatibility.


Contents Index QUOTE_ALL_IDENTIFIERS option [replication] READ_PAST_DELETED option [database]