SQL Remote User's Guide
System Objects for Adaptive Server Anywhere
SQL Remote system tables
Each row describes an article in a SQL Remote publication.
| Column | Data type | Description |
|---|---|---|
| publication_id | UNSIGNED INT | The publication of which this article is a part. |
| table_id | UNSIGNED INT | Each article consists of columns and rows from a single table. This column contains the table ID for this table. |
| where_expr | LONG VARCHAR | For articles that contain a subset of rows defined by a WHERE clause, this column contains the search condition. |
| subscribe_by_expr | LONG VARCHAR | For articles that contain a subset of rows defined by a SUBSCRIBE BY expression, this column contains the expression. |
| query | CHAR(1) | The SUBSCRIBE BY expression could be a subquery that returns multiple values. This column contains Y or N to indicate if the expression is a subquery (Y) or not (N). This column is used by the Extraction utility |