Sybase Adaptive Server Anywhere - SYSARTICLE System Table

Chapter 15 System Tables
997
SYSARTICLE system table
Column name Column type
Column
constraint
Table constraints
publication_id UNSIGNED
INT
NOT NULL Primary key, foreign key
references
SYSPUBLICATION
table_id UNSIGNED
INT
NOT NULL Primary key, foreign key
references SYSTABLE
where_expr LONG
VARCHAR
subscribe_by_expr LONG
VARCHAR
query CHAR(1) NOT NULL
Each row of SYSARTICLE describes an article in a SQL Remote
publication.
publication_id The publication of which this article is a part.
table_id Each article consists of columns and rows from a single table.
This column contains the table ID for 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.