If option-value is omitted, the specified option setting is removed from the database. If it was a personal option setting, the value reverts back to the PUBLIC setting. If a TEMPORARY option is deleted, the option setting reverts back to the permanent setting.
For example, the following statement resets the ansi_blanks option to its default value:
SET OPTION ansi_blanks =; |
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |