ASA SQL Reference
System Tables
| Column name | Column type | Column constraint | Table constraints |
|---|---|---|---|
| publication_id | UNSIGNED INT | NOT NULL | Primary key, foreign key references SYSPUBLICATION |
| table_id | UNSIGNED INT | NOT NULL | Primary key, foreign key references SYSTABLE |
| where_expr | LONG VARCHAR | ||
| subscribe_by_expr | LONG VARCHAR | ||
| query | CHAR(1) | NOT NULL |
Each row of SYSARTICLE describes an article in a publication.
publication_id The publication of which this article is a part.
table_id Each article consists of columns and rows from a single table. This column contains the table ID for this table.
where_expr For articles that contain a subset of rows defined by a WHERE clause, this column contains the search condition.
subscribe_by_expr For articles that contain a subset of rows defined by a SUBSCRIBE BY expression, this column contains the expression.
query Indicates information about the article type to the database server.