Contents Index Setting public options Option classification

ASA Database Administration Guide
  Database Options
    Introduction to database options

Deleting option settings


If option-value is omitted, the specified option setting will be deleted 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_INTEGER_OVERFLOW option to its default value:

SET OPTION ANSI_INTEGER_OVERFLOW =

For more information, see SET OPTION statement.


Contents Index Setting public options Option classification