MSarticles (Transact-SQL)

The MSarticles table contains one row for each article being replicated by a Publisher. This table is stored in the distribution database.

Column name

Data type

Description

publisher_id

smallint

The ID of the Publisher.

publisher_db

sysname

The name of the Publisher database.

publication_id

int

The ID of the publication.

article

sysname

The name of the article.

article_id

int

The ID of the article.

destination_object

sysname

The name of the table created at the Subscriber.

source_owner

sysname

The name of the schema of the source table at the Publisher.

source_object

sysname

The name of the source object from which to add the article.

description

nvarchar(255)

The description of the article.

destination_owner

sysname

The name of the schema of the table created at the Subscriber.