SYSARTICLE system table

CREATE TABLE SYS.SYSARTICLE (
	publication_id	 UNSIGNED INT NOT NULL,
	table_id	 UNSIGNED INT NOT NULL,
	where_expr	 LONG VARCHAR,
	subscribe_by_expr	 LONG VARCHAR,
	query	 CHAR(1) NOT NULL,
	PRIMARY KEY ( publication_id, table_id ),
	FOREIGN KEY REFERENCES SYS.SYSPUBLICATION,
	FOREIGN KEY REFERENCES SYS.SYSTABLE
)

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.