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

Page 364
Image 364
Sybase DC38133-01-0902-01 manual Srarticles view, Srarticlecols view, Srpublications view