Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » Views » System views in Sybase Central

SYSOBJECT system view Next Page

SYSOPTION system view


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.

Columns
Column name Column type Column constraint
user_id UNSIGNED INT NOT NULL
"option" CHAR(128) NOT NULL
"setting" LONG VARCHAR NOT NULL

user_id    The user number to whom the option setting applies.

option    The name of the option.

setting    The current setting for the option.

Constraints on underlying system table

PRIMARY KEY (user_id, "option")

FOREIGN KEY (user_id) references SYS.ISYSUSER (user_id)