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

SYSREMARK system view Next Page

SYSREMOTEOPTION system view


Each row in the SYSREMOTEOPTION system view describes the value of a SQL Remote message link parameter. The underlying system table for this view is ISYSREMOTEOPTION.

Columns
Column Data type Column Constraint
option_id UNSIGNED INT NOT NULL
user_id UNSIGNED INT NOT NULL
"setting" VARCHAR(255) NOT NULL

Some columns in this view contain potentially sensitive data. For that reason, access to this view is restricted to users with DBA authority. The SYSREMOTEOPTION2 view provides public access to the data in this view except for the potentially sensitive columns.

option_id    An identification number for the message link parameter.

user_id    The user ID for which the parameter is set.

"setting"    The value of the message link parameter.

Constraints on underlying system table

PRIMARY KEY (option_id, user_id)

FOREIGN KEY (option_id) references SYS.ISYSREMOTEOPTIONTYPE (option_id)