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

SYSARTICLE system view Next Page

SYSARTICLECOL system view


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

Columns
Column name Column type Column constraint
publication_id UNSIGNED INT NOT NULL
table_id UNSIGNED INT NOT NULL
column_id UNSIGNED INT NOT NULL

publication_id    A unique identifier for the publication of which the column is a part.

table_id    The table to which the column belongs.

column_id    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)