User's Manual

SQL Remote system views
This section describes the database views used by SQL Remote to present
and summarize SQL Remote information.
sr_articles view
Function Each row lists describes an article.
Columns
Column Description
publication_name The publication of which this article is a part.
table_name Each article consists of columns and rows from a
single table. This column contains the name of this
table.
where_expr For articles that contain a subset of rows defined by
a WHERE clause, this column contains the search
condition.
subscribe_by_expr For articles that contain a subset of rows defined by
a SUBSCRIBE BY expression, this column contains
the expression.
subscribe_by_view For articles that contain a subset of rows defined by
a view, this column contains the name of the view.
sr_articlecols view
Function Each row describes a column that appears in an article.
Columns
Column Description
publication_name The name of the publication of which the column is a
part.
table_name The name of the table to which the column belongs.
column_name The column name.
sr_publications view
Function Lists the names of all publications.
346