Sybase DC38133-01-0902-01 Sysarticlecol table, It is in, and the publication it is part, 327

Chapter 15. System Objects for Adaptive Server Anywhere

Columns

Column	Data type	Description
publication_id	UN-	The publication of which this article
	SIGNED INT	is a part.
table_id	UN-	Each article consists of columns
	SIGNED INT	and rows from a single table. This
		column contains the table ID for this
		table.
where_expr	LONG VAR-	For articles that contain a subset of
	CHAR	rows defined by a WHERE clause,
		this column contains the search
		condition.
subscribe_by_-	LONG VAR-	For articles that contain a subset of
expr	CHAR	rows defined by a SUBSCRIBE BY
		expression, this column contains the
		expression.
query	CHAR(1)	The SUBSCRIBE BY expression
		could be a subquery that returns mul-
		tiple values. This column contains
		Y or N to indicate if the expression
		is a subquery (Y) or not (N). This
		column is used by the Extraction
		utility

SYSARTICLECOL table

Function	Each row identifies a column in an article, identifying the column, the table
	it is in, and the publication it is part of.
Columns
	Column	Data type	Description
	publication_id	UN-	A unique identifier for the publication of
		SIGNED INT	which the column is a part.
	table_id	UN-	The table to which the column belongs.
		SIGNED INT
	column_id	UN-	The column identifier, from the
		SIGNED INT	SYSCOLUMN system table.

327