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

SQL Anywhere 11.0.1 » SQL Anywhere Server - SQL Reference » System Objects » Views » System views



Each row of the SYSARTICLECOL system view identifies a column in an article. The underlying system table for this view is ISYSARTICLECOL.

Column name Column type Description
publication_id UNSIGNED INT A unique identifier for the publication of which the column is a part.
table_id UNSIGNED INT The table to which the column belongs.
column_id UNSIGNED INT The column identifier, from the SYSTABCOL system view.
Constraints on underlying system table

PRIMARY KEY (publication_id, table_id, column_id)

FOREIGN KEY (publication_id, table_id) references SYS.ISYSARTICLE (publication_id, table_id)

FOREIGN KEY (table_id, column_id) references SYS.ISYSTABCOL (table_id, column_id)