Deleting option settings

If option-value is omitted, the specified option setting is deleted from the database. If option-value 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, this statement resets the ANSINULL option to its default value:

SET OPTION ANSINULL =

If you incorrectly type the name of an option when you are setting the option, the incorrect name is saved in the SYSOPTION table. You can remove the incorrectly typed name from the SYSOPTION table by setting the option PUBLIC with an equality after the option name and no value:

SET OPTION PUBLIC.a_mistyped_name=;

For example, if you set an option and incorrectly type the name, you can verify that the option was saved by selecting from the SYSOPTIONS view:

SET OPTION PUBLIC.a_mistyped_name='ON';
SELECT * FROM SYSOPTIONS ORDER BY 2;

user_name

option

setting

PUBLIC

a_mistyped_name

ON

PUBLIC

Abort_On_Error_File

PUBLIC

Abort_On_Error_Line

0

PUBLIC

Abort_On_Error_Number

0

...

You can remove the incorrectly typed option by setting it to no value, then verify that the option is removed:

SET OPTION PUBLIC.a_mistyped_name=;
SELECT * FROM SYSOPTIONS ORDER BY 2;

user_name

option

setting

PUBLIC

Abort_On_Error_File

PUBLIC

Abort_On_Error_Line

0

PUBLIC

Abort_On_Error_Number

0

...