rs_articles

Stores information about articles known to this Replication Server.

Column

Datatype

Description

articlename

varchar(255)

Name of the article

articleid

rs_id

Unique article ID

type

char(1)

  • T – table

  • P – procedure

primaryname

varchar(255)

Primary table or procedure name

primaryowner

varchar(30)

Primary table owner name

objid

rs_id

ID of the corresponding replication definition

pubid

rs_id

ID of the publication to which this article belongs

requestdate

datetime

Date and time the article was added to the publication

minvers

int

Minimum Replication Server version required to support this article

Indexes

  • Unique clustered index on (articlename, pubid)

  • Unique index on (articleid)