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

SYSFKEY system view Next Page

SYSGROUP system view


There is one row in the SYSGROUP system view for each member of each group. This view describes the many-to-many relationship between groups and members. A group may have many members, and a user may be a member of many groups. The underlying system table for this view is ISYSGROUP.

Columns
Column name Column type Column constraint
group_id UNSIGNED INT NOT NULL
group_member UNSIGNED INT NOT NULL

group_id    The user number of the group.

group_member    The user number of a member.

Constraints on underlying system table

PRIMARY KEY (group_id, group_member)

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

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