Reference Manual
CHAPTER 15. System Tables
Column name |
Column type |
Column constraint |
Table constraints |
|---|---|---|---|
publication_id |
SMALLINT |
NOT NULL |
Primary key |
table_id |
SMALLINT |
NOT NULL |
Primary key |
where_expr |
LONG VARCHAR |
||
subscribe_by_expr |
LONG VARCHAR |
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.