MSarticles

Transact-SQL Reference

Transact-SQL Reference

MSarticles

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 ID of the Publisher.
publisher_db sysname Name of the Publisher database.
publication_id int ID of the publication.
article sysname Name of the article.
article_id int ID of the article.
destination_object sysname Name of the table created at the Subscriber.
source_owner sysname Name of the owner of the source table at the Publisher.
source_object sysname Name of the source object from which to add the article.
description nvarchar(255) Description of the article.