msarticles-transact-sql.md

title	MSarticles (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/03/2017
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	replication
ms.topic	language-reference
f1_keywords	MSarticles MSarticles_TSQL
dev_langs	TSQL
helpviewer_keywords	MSarticles system table
ms.assetid	1acd79a5-b3e2-4161-9592-7acc2a41ba38
author	stevestein
ms.author	sstein

MSarticles (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

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)