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.

Column name	Data 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.

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)

Discuss this page in DocCommentXchange.