User's Manual

Chapter 16. System Objects for Adaptive Server Enterprise
Column Data type Description
publication_id INT The publication of which this arti-
cle 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.
sr_articlecol table
Function Each row identifies a column in an article, identifying the column, the table
it is in, and the publication it is part of.
Columns
Column Data type Description
publication_id INT A unique identifier for the publication of
which the column is a part.
table_id INT The table to which the column belongs.
column_id INT The column identifier, from the
SYSCOLUMN system table.
sr_marker table
Function To ensure that messages received by the Message Agent are sent to remote
databases in the same session.
Columns
339