Each row in the SYSSUBSCRIPTION system view describes a subscription from one user ID (which must have REMOTE permissions) to one publication. The underlying system table for this view is ISYSSUBSCRIPTION.
| Column name | Column type | Description |
|---|---|---|
| publication_id | UNSIGNED INT | The identifier for the publication to which the user ID is subscribed. |
| user_id | UNSIGNED INT | The ID of the user who is subscribed to the publication. |
| subscribe_by | CHAR(128) | The value of the SUBSCRIBE BY expression, if any, for the subscription. |
| created | UNSIGNED BIGINT | The offset in the transaction log at which the subscription was created. |
| started | UNSIGNED BIGINT | The offset in the transaction log at which the subscription was started. |
PRIMARY KEY (publication_id, user_id, subscribe_by)
FOREIGN KEY (publication_id) references SYS.ISYSPUBLICATION (publication_id)
FOREIGN KEY (user_id) 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 |