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

SQL Anywhere 11.0.0 » SQL Anywhere Server - SQL Reference » System Objects » Views » System views


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.

Column name Column type Description
group_id UNSIGNED INT The user number of the group.
group_member UNSIGNED INT The user number of a member.
Constraints on underlying system table

PRIMARY KEY (group_id, group_member)

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

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