ANSI quoted identifiers

 

SQL statements are generated using ANSI quoted identifiers.
Column/Table/View names with, for example space characters or reserved keywords, can be used.

EXAMPLE: The following SQL Statement will fail if executed without ANSI quoted identifiers.

Select My Column from My Table

 

If executed using ANSI quoted identifiers, the statement will be translated to:

Select “My Column” from “My Table”, and the execution will succeed.

 


IMPORTANT: if you are using old ODBC drivers, please upgrade to version that supports ANSI quoted identifiers!

If your database does not support ANSI quoted identifiers, or you are not using space characters, uncheck the checkbox.