Has a row for each of the articles posted by the publishing server.
| Column | Datatype | Description |
|---|---|---|
| artid | int | An identity column providing a unique ID number for the article. |
| columns | varbinary(32) | The columns in the tables that are being published. |
| creation_script | varchar(127) | The schema script for the article. |
| del_cmd | varchar(255) | Command to execute upon delete, else construct from the log. |
| description | varchar(255) | Descriptive entry for the article. |
| dest_table | varchar(30) | Name of the destination table. |
| filter | int | The stored procedure ID, used for horizontal partitioning. |
| filter_clause | text | The WHERE clause of the article, used for horizontal filtering. |
| ins_cmd | varchar(255) | Command to execute upon insert, else construct from the log. |
| name | varchar(30) | Name associated with the article. Unique within the publication. |
| objid | int | Published table object ID. |
| pubid | int | ID of the publication to which the article belongs. |
| pre_creation_cmd | tinyint | A pre-creation command for drop table, delete table, or truncate: 0 None 1 Drop 2 Delete 3 Truncate |
| status | tinyint | Bitmap used to describe a property of the column or the parameter: 0x08 The column allows null values. 0x40 The parameter is an OUTPUT parameter. 0x80 The column is an identity column. |
| 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 | varchar(255) | Command to execute upon update, or else construct from the log. |
unc1sysarticles nonclustered, unique on artid, pubid
| sp_addarticle | sp_droparticle | sp_helparticlecolumns |
| sp_addsubscription | sp_droppublication | sp_helppublication |
| sp_articlecolumn | sp_dropsubscription | sp_helpsubscription |
| sp_changearticle | sp_enumfullsubscribers | sp_subscribe |
| sp_changesubscription | sp_helparticle | sp_unsubscribe |
| sp_changesubstatus |