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

SQL Anywhere 11.0.1 » UltraLite - Database Management and Reference » UltraLite Database Reference » UltraLite system tables


sysarticle system table

Each row in the sysarticle system table describes a table that belongs to a publication.

Column name Column type Description
publication _id UNSIGNED INT An identifier for the publication that this article belongs to.
table_id UNSIGNED INT The identifier of the table that belongs to the publication.
where_expr TINY INT An optional predicate to filter rows.

PRIMARY KEY (publication_id, table_id)

FOREIGN KEY (publication_id) REFERENCES syspublication (publication_id)

FOREIGN KEY (table_id) REFERENCES systable (object_id)

See also