Contains one row for each merge article defined in the local database. This table is stored in the published database.
| Column name | Data type | Description |
|---|---|---|
| name | sysname | Name of the article. |
| type | tinyint | Article type. |
| objid | int | Object identifier. |
| sync_objid | int | Object ID of the view representing the synchronized data set. |
| view_type | tinyint | Type of view: 0 = Not a view; use all of base object. 1 = Permanent view. 2 = Temporary view. |
| artid | uniqueidentifier | Identity column used to provide a unique identification number for the given article. artid is derived from sysobjects.srcid. |
| description | nvarchar(255) | Brief description of the article. |
| pre_creation_command | nvarchar(10) | Default action to take when the article is created in the subscription database: None = If the table already exists at the Subscriber, no action is taken. Delete = Issues a delete based on the WHERE clause in the subset filter. Drop (default) = Drops the table before re-creating it. Truncate = Same as delete, but deletes pages instead of rows. Does not take a WHERE clause, however. |
| pubid | uniqueidentifier | ID of the publication to which the current article belongs. |
| nickname | int | Nickname mapping for article identification. |
| column_tracking | int | Indicates whether column tracking is implemented for the article. |
| status | tinyint | Bitmap used to indicate the status of the article. |
| conflict_table | sysname | Name of the local table that contains the conflicting records for the current article. This table is supplied for information only, and its contents may be modified or deleted by custom conflict resolution routines or directly by the administrator. |
| creation_script | nvarchar(255) | Creation script for this article. |
| conflict_script | nvarchar(255) | Conflict script for this article. |
| article_resolver | nvarchar(255) | Custom row-level conflict resolver for this article. |
| ins_conflict_proc | sysname | Procedure used to write conflict to conflict_table. |
| insert_proc | sysname | Procedure used by the default conflict resolver to insert rows during synchronization. |
| update_proc | sysname | Procedure used by the default conflict resolver to update rows during synchronization. |
| schema_option | binary(8) | Indicates what is to be scripted out. |
| destination_object | sysname | Name of the table created at the Subscriber. |
| resolver_clsid | nvarchar(1000) | ID of the custom conflict resolver. |
| subset_filterclause | nvarchar(2000) | Filter clause for this article. |
| missing_col_count | int | Number of missing columns. |
| missing_cols | varbinary(128) | Bit map of missing columns. |
| columns | varbinary(128) | Reserved for future use. |
| resolver_info | sysname | Storage for additional information required by custom conflict resolvers. |