Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » Views » System views in Sybase Central

System views in Sybase Central Next Page

SYSARTICLE system view


Each row of the SYSARTICLE system view describes an article in a publication. The underlying system table for this view is ISYSARTICLE.

Columns
Column name Column type Column constraint
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
aliasVARCHAR(256)

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.

Constraints on underlying system table

PRIMARY KEY (publication_id, table_id)

FOREIGN KEY (publication_id) references SYS.ISYSPUBLICATION (publication_id)

FOREIGN KEY (table_id) references SYS.ISYSTAB (table_id)