The SYSOPTION system view contains the options one row for each option setting stored in the database. Each user can have their own setting for a given option. In addition, settings for the PUBLIC user ID define the default settings to be used for users that do not have their own setting. The underlying system table for this view is ISYSOPTION.
| Column name | Data type | Description |
|---|---|---|
| user_id | UNSIGNED INT | The user number to whom the option setting applies. |
| "option" | CHAR(128) | The name of the option. |
| "setting" | LONG VARCHAR | The current setting for the option. |
PRIMARY KEY (user_id, "option")
FOREIGN KEY (user_id) references SYS.ISYSUSER (user_id)