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. |
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)
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |