SQL Remote User's Guide
System Objects for Adaptive Server Enterprise
SQL Remote system tables
Each row describes a subscription from one user ID (which must have REMOTE permissions) to one publication.
| Column | Data type | Description |
|---|---|---|
| publication_id | INT | The identifier for the publication to which the user ID is subscribed. |
| user_id | INT | The user ID that is subscribed to the publication. |
| subscribe_by | VARCHAR(128) | For publications with a SUBSCRIBE BY expression, this column holds the matching value for this subscription. |
| created | NUMERIC(20, 0) | The offset in the transaction log at which the subscription was created. |
| started | NUMERIC(20, 0) | The offset in the transaction log at which the subscription was started. |
| operation | VARCHAR(20) |