sysextendedarticlesview-transact-sql.md

title	sysextendedarticlesview (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/03/2017
ms.prod	sql-server-2016
ms.reviewer
ms.suite
ms.technology	replication
ms.tgt_pltfrm
ms.topic	language-reference
applies_to	SQL Server
f1_keywords	sysextendedarticlesview_TSQL sysextendedarticlesview
dev_langs	TSQL
helpviewer_keywords	sysextendedarticlesview view
ms.assetid	8bdd22f7-c268-49b6-820c-3fe603feb128
caps.latest.revision	11
author	BYHAM
ms.author	rickbyh
manager	jhubbard

sysextendedarticlesview (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]

The sysextendedarticlesview view provides information about published articles. This view is stored in the distribution database.

Column name	Data type	Description
artid	int	The identity column that provides a unique ID number for the article.
creation_script	nvarchar(255)	The schema creation script for the article.
del_cmd	nvarchar(255)	The command to execute upon DELETE; otherwise, construct from the log.
description	nvarchar(255)	The descriptive entry for the article.
dest_table	nvarchar(128)	The name of the destination table.
filter	int	The object identifier of the stored procedure used for horizontal partitioning.
filter_clause	ntext	The WHERE clause of the article, used for horizontal filtering.
ins_cmd	nvarchar(255)	The command to execute upon INSERT.
name	nvarchar(128)	The name associated with the article, unique within the publication.
objid	int	The published table object ID.
pubid	int	The ID of the publication to which the article belongs.
pre_creation_cmd	tinyint	The pre-creation command for DROP TABLE, DELETE TABLE, or TRUNCATE: 0 = None. 1 = DROP. 2 = DELETE. 3 = TRUNCATE.
status	int	The bitmask of the article options and status, which can be the bitwise logical OR result of one or more of these values: 1 = Article is active. 8 = Include the column name in INSERT statements. 16 = Use parameterized statements. 24 = Both include the column name in INSERT statements and use parameterized statements. For example, an active article using parameterized statements would have a value of 17 in this column. A value of 0 means that the article is inactive and no additional properties are defined.
sync_objid	int	The ID of the table or view that represents the article definition.
type	tinyint	The type of article: 1 = Log-based article. 3 = Log-based article with manual filter. 5 = Log-based article with manual view. 7 = Log-based article with manual filter and manual view.
upd_cmd	nvarchar(255)	The command to execute upon UPDATE; otherwise, construct from the log.
schema_option	binary	Indicates what properties of the published object are scripted out in the snapshot. For a list of supported schema options, see sp_addarticle.
dest_owner	nvarchar(128)	The owner of the table at the destination database.
ins_scripting_proc	int	The object identifier of the custom stored procedure or script that is executed when an INSERT statement is replicated.
del_scripting_proc	int	The object identifier of the custom stored procedure or script that is executed when a DELETE statement is replicated.
upd_scripting_proc	int	The object identifier of the custom stored procedure or script that is executed when an UPDATE statement is replicated.
custom_script	int	The object identifier of the custom script or procedure that is executed on the completion of a DDL trigger.
fire_triggers_on_snapshot	int	Indicates whether replicated triggers are executed when the snapshot is applied, which can be one of these values: 0 = Triggers are not executed. 1 = Triggers are executed.

See Also

Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)
sp_addarticle (Transact-SQL)
sp_changearticle (Transact-SQL)
sp_helparticle (Transact-SQL)
sysarticles (Transact-SQL)