Replicate article fields table

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.

Table A-12: Replicate article 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.