sysextendedarticlesview (Transact-SQL)

sysextendedarticlesview (Transact-SQL)


Applies To: SQL Server

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

Column nameData typeDescription
artidintThe identity column that provides a unique ID number for the article.
creation_scriptnvarchar(255)The schema creation script for the article.
del_cmdnvarchar(255)The command to execute upon DELETE; otherwise, construct from the log.
descriptionnvarchar(255)The descriptive entry for the article.
dest_tablenvarchar(128)The name of the destination table.
filterintThe object identifier of the stored procedure used for horizontal partitioning.
filter_clausentextThe WHERE clause of the article, used for horizontal filtering.
ins_cmdnvarchar(255)The command to execute upon INSERT.
namenvarchar(128)The name associated with the article, unique within the publication.
objidintThe published table object ID.
pubidintThe ID of the publication to which the article belongs.
pre_creation_cmdtinyintThe pre-creation command for DROP TABLE, DELETE TABLE, or TRUNCATE:

 0 = None.

 1 = DROP.

 2 = DELETE.

statusintThe 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_objidintThe ID of the table or view that represents the article definition.
typetinyintThe 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_cmdnvarchar(255)The command to execute upon UPDATE; otherwise, construct from the log.
schema_optionbinaryIndicates what properties of the published object are scripted out in the snapshot. For a list of supported schema options, see sp_addarticle.
dest_ownernvarchar(128)The owner of the table at the destination database.
ins_scripting_procintThe object identifier of the custom stored procedure or script that is executed when an INSERT statement is replicated.
del_scripting_procintThe object identifier of the custom stored procedure or script that is executed when a DELETE statement is replicated.
upd_scripting_procintThe object identifier of the custom stored procedure or script that is executed when an UPDATE statement is replicated.
custom_scriptintThe object identifier of the custom script or procedure that is executed on the completion of a DDL trigger.
fire_triggers_on_snapshotintIndicates 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.

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

Community Additions

© 2016 Microsoft