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

SQL Anywhere 11.0.0 » SQL Anywhere Server - Database Administration » Configuring Your Database » Database options » Introduction to database options » Alphabetical list of options


non_keywords option [compatibility]

Turns off individual keywords, allowing their use as identifiers.

Allowed values



Empty string


This option turns off individual keywords. This provides a way of ensuring that applications created with older versions of the product are not broken by new keywords. If you have an identifier in your database that is now a keyword, you can either add double quotes around the identifier in all applications or scripts, or turn off the keyword using the non_keywords option.

The following statement prevents TRUNCATE and SYNCHRONIZE from being recognized as keywords:


Each new setting of this option replaces the previous setting. The following statement clears all previous settings.

SET OPTION non_keywords =;

A side-effect of this option is that SQL statements that use a turned off keyword cannot be used: they produce a syntax error.

See also