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

SYSSQLSERVERTYPE system view Next Page

SYSSUBSCRIPTION system view


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.

Columns
Column name Column type Column constraint
publication_id UNSIGNED INT NOT NULL
user_id UNSIGNED INT NOT NULL
subscribe_by CHAR(128) NOT NULL
created UNSIGNED BIGINT NOT NULL
started UNSIGNED BIGINT

publication_id    The identifier for the publication to which the user ID is subscribed.

user_id    The ID of the user who is subscribed to the publication.

subscribe_by    The value of the SUBSCRIBE BY expression, if any, for the subscription.

created    The offset in the transaction log at which the subscription was created.

started    The offset in the transaction log at which the subscription was started.

Constraints on underlying system table

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)