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|