SQL Remote User's Guide
System Objects for Adaptive Server Enterprise
SQL Remote system tables
Each row describes an article in a SQL Remote publication.
Column | Data type | Description |
---|---|---|
publication_id | INT | The publication of which this article is a part. |
table_id | INT | Each article consists of columns and rows from a single table. This column contains the table ID for this table. |
where_expr | VARCHAR(128) | For articles that contain a subset of rows defined by a WHERE clause, this column contains the search condition. |
subscribe_by_expr | VARCHAR(128) | For articles that contain a subset of rows defined by a SUBSCRIBE BY expression, this column contains the expression. |
subscribe_by_view | VARCHAR(128) | For articles that contain a subset of the rows defined by a view. This column contains the name of the view. |