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.