MSarticles (Transact-SQL)


Applies To: SQL Server

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

Column nameData typeDescription
publisher_idsmallintThe ID of the Publisher.
publisher_dbsysnameThe name of the Publisher database.
publication_idintThe ID of the publication.
articlesysnameThe name of the article.
article_idintThe ID of the article.
destination_objectsysnameThe name of the table created at the Subscriber.
source_ownersysnameThe name of the schema of the source table at the Publisher.
source_objectsysnameThe name of the source object from which to add the article.
descriptionnvarchar(255)The description of the article.
destination_ownersysnameThe name of the schema of the table created at the Subscriber.

Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)

Community Additions