The rart_fields table stores information about all subscribed fields for all replicate articles.
Table A-12 lists the columns in the rart_fields table.
Column name |
Datatype |
Description |
---|---|---|
rart_id |
numeric(18,0) |
Replicate article ID |
rart_colid |
smallint |
Column ID of replicate article field |
rart_colname |
rpl_sysname |
Column name of replicate article field |
is_identity |
rpl_boolean |
Indicates whether the column is an identity column |
is_lob |
rpl_boolean |
Indicates whether the column is a large object datatype |
is_null |
rpl_boolean |
Indicates whether the column can have a null value |
dtype |
int |
Column datatype ID |
dtype_name |
rpl_sysname |
Column datatype name |
prec |
int |
Length of string or binary field, or precision of a numeric field, if applicable |
scale |
smallint |
Scale of numeric field, if applicable |
proxy_colid |
smallint |
Column ID of proxy table column |
proxy_colname |
rpl_sysname |
Column name of proxy table column |
part_id |
numeric(18,0) |
ID of primary article to which the replicate article subscribes |
part_colid |
int |
Column ID of primary article field |
part_colname |
rpl_sysname |
Column name of primary article field |
Each row in the rart_fields table identifies a single subscribed field in a replicate article.
When you create a replicate article, a row is added to the rart_fields table for each subscribed field in the new article.
When you delete a replicate article, a row is deleted from the rart_fields table for each subscribed field in that article.