ASA SQL Reference
System Tables
| Column name | Column type | Column constraint | Table constraints |
|---|---|---|---|
| user_id | UNSIGNED INT | NOT NULL | Primary key, foreign key references SYSUSERPERM |
| "option" | CHAR(128) | NOT NULL | Primary key |
| "setting" | LONG VARCHAR | NOT NULL |
Options settings are stored in the SYSOPTION table by the SET command. Each user can have their own setting for each option. In addition, settings for the PUBLIC user ID define the default settings to be used for user IDs that do not have their own setting.
user_id The user number to whom this option setting applies.
option The name of the option.
setting The current setting for the named option.