MS SQL Server, Sybase, and SQL Anywhere QUOTED_IDENTIFIER settings

By default, the drivers RazorSQL uses to connect to SQL Server, Sybase and SQL Anywhere databases set the QUOTED_IDENTIFIER setting to ON.

To change the status of the QUOTED_IDENTIFIER, the following statement would need to be executed:


The RazorSQL tools that generate SQL use the select @@OPTIONS query to determine the status of the QUOTED_IDENTIFIER before generating SQL. If QUOTED_IDENTIFIER is set to ON, RazorSQL wraps objects with spaces or special characters in double-quotes. If QUOTED_IDENTIFIER is OFF, RazorSQL uses braces to wrap objects.

If care is taken to make sure that any names used are not the names of existing database objects or contain spaces or special characters, there is little potential for conflicts.