Contents Index #remote table sr_articlecol table

SQL Remote User's Guide
  System Objects for Adaptive Server Enterprise
    SQL Remote system tables

sr_article table


Function 

Each row describes an article in a SQL Remote publication.

Columns 
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.

Contents Index #remote table sr_articlecol table