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