sysextendedarticlesview (Transact-SQL)
Applies to: 
SQL Server
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)