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)