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 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