create table DBA.SYSOPTIONDEFAULTS ( option_name varchar(128), default_value varchar(40) )
The SYSOPTIONDEFAULTS table stores the default option settings. These values do not change. The sp_iqcheckoptions stored procedure compares the default value in the SYSOPTIONDEFAULTS table to the current setting of the option in the SYSOPTION table and displays the values that have changed for the connected user.
If you query the option_name column
of this table in a case-sensitive database, you must match case
of the option. For example, the MAIN_CACHE_MEMORY_MB
option is stored in SYSOPTIONDEFAULTS as Main_Cache_Memory_MB.
You can run a select * from
the SYSOPTIONDEFAULTS table to see the exact
case of the option.
