Each row of the SYSARTICLE system view describes an article in a publication. The underlying system table for this view is ISYSARTICLE.
|Column name||Column type||Column constraint|
|publication_id||UNSIGNED INT||NOT NULL|
|table_id||UNSIGNED INT||NOT NULL|
publication_id The publication of which the 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.
query Indicates information about the article type to the database server.
alias The alias for the article.
PRIMARY KEY (publication_id, table_id)
FOREIGN KEY (publication_id) references SYS.ISYSPUBLICATION (publication_id)
FOREIGN KEY (table_id) references SYS.ISYSTAB (table_id)