SQL Anywhere® Server - Database Administration  > Database Options  > Introduction to database options  > Alphabetical list of options

non_keywords option [compatibility]

Turns off individual keywords, allowing their use as identifiers.

String

Empty string

This option turns off individual keywords or all keywords introduced since a specific release of the product. 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.

In addition to specifying individual keywords, you can turn off all keywords since a specified release using one of the following special values in the list of keywords:

keywords_4_0_d, keywords_4_0_c, keywords_4_0_b, keywords_4_0_a, keywords_4_0, keywords_5_0_01, keywords_5_0

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

SET OPTION non_keywords = 'TRUNCATE, SYNCHRONIZE';

The following statement prevents all keywords introduced since version 4.0.d from being recognized as keywords:

SET OPTION non_keywords = 'keywords_4_0_d';

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.

• Keywords