User's Manual

Chapter 15. System Objects for Adaptive Server Anywhere
SQL Remote system views
This section describes the database views used by SQL Remote to present
and summarize SQL Remote information.
SYSARTICLES 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.
SYSARTICLECOLS 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.
SYSPUBLICATIONS view
Function Lists the names of all publications.
Columns
333