The pri_articles table stores information about all ASE Replicator primary articles.
Table A-7 lists the columns in the pri_articles table.
Column name |
Datatype |
Description |
|---|---|---|
part_id |
numeric(18,0) |
Primary article ID |
part_name |
rpl_sysname |
Name of primary article |
conn_id |
numeric(18,0) |
Connection ID |
art_type |
smallint |
Type of primary article (table or procedure) |
shadow |
rpl_sysname |
Name of primary article shadow table |
rarts_count |
int |
Number of replicate articles subscribing to this primary article |
owner |
rpl_sysname |
Owner of the primary object |
proc_num |
smallint |
Stored procedure group number |
Each row in the pri_articles table identifies a single primary article.
When you create a primary article, a row is added to the pri_articles table for the new article.
When you create or delete a replicate article, the row that identifies the primary article subscribed to by that replicate article is updated in the pri_articles table to change the value of the rarts_count column.
When you delete a primary article, the row that identifies that primary article is deleted from the pri_articles table.
