The SYSUSEROPTIONS view contains the option settings that are in effect for each user. If a user has no setting for an option, this view displays the public setting for the option.
The tables and columns that make up this view are provided in the SQL statement below. To learn more about a particular table or column, use the links provided beneath the view definition.
ALTER VIEW "SYS"."SYSUSEROPTIONS"( user_name, "option",setting ) as select u.user_name, o."option", isnull((select s.setting from SYS.ISYSOPTION as s where s.user_id = u.user_id and s."option" = o."option"), o.setting) from SYS.SYSOPTIONS as o,SYS.ISYSUSER as u where o.user_name = 'PUBLIC' |
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |