msarticles-transact-sql.md

title	MSarticles (Transact-SQL)
description	MSarticles (Transact-SQL)
author	VanMSFT
ms.author	vanto
ms.date	03/03/2017
ms.service	sql
ms.subservice	replication
ms.topic	reference
f1_keywords	MSarticles MSarticles_TSQL
helpviewer_keywords	MSarticles system table
dev_langs	TSQL

MSarticles (Transact-SQL)

[!INCLUDE 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

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