Collection Contents Index SYSARTICLE system table SYSCOLLATION system table pdf/chap15.pdf

Reference Manual
   CHAPTER 15. System Tables     

SYSARTICLECOL system table


Column name

Column type

Column constraint

Table constraints

publication_id

SMALLINT

NOT NULL

Primary Key, foreign key references SYS.SYSARTICLE

table_id

SMALLINT

NOT NULL

Primary Key, foreign key references SYS.SYSARTICLE, SYS.SYSCOLUMN

column_id

SMALLINT

NOT NULL

Primary Key, foreign key references SYS.SYSCOLUMN

Each row identifies a column in an article.

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 SYSCOLUMN system table.


Collection Contents Index SYSARTICLE system table SYSCOLLATION system table pdf/chap15.pdf