MSarticles (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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.

See Also

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