Applies To: SQL Server
Tracks schema-only articles for merge replication. This table is stored in the publication and subscription databases.
|Column name||Data type||Description|
|name||sysname||The name of the schema-only article in the merge publication.|
|type||tinyint||Indicates the type of schema-only article, which can be one of the following:|
0x20 = Stored procedure schema-only article.
0x40 = View schema-only article or indexed view schema-only article.
|objid||int||The object identifier of the article base object. Can be the object identifier of a procedure, view, indexed, view, or user-defined function.|
|artid||uniqueidentifier||The article ID.|
|description||nvarchar(255)||The description of the article.|
|pre_creation_command||tinyint||Default action to take when the article is created in the subscription database:|
0 = None - if the table already exists at the Subscriber, no action is taken.
1 = Drop - drops the table before re-creating it.
2 = Delete -issues a delete based on the WHERE clause in the subset filter.
3 = Truncate -same as 2, but deletes pages instead of rows. However, does not take a WHERE clause.
|pubid||uniqueidentifier||The unique identifier of the publication.|
|status||tinyint||Indicates the status of the schema-only article, which can be one of the following:|
1 = Unsynced - the initial processing script to publish the table runs the next time the Snapshot Agent runs.
2 = Active - the initial processing script to publish the table has been run.
5 = New_inactive - to be added.
6 = New_active - to be added.
|creation_script||nvarchar(255)||The path and name of an optional article schema pre-creation script used to create target table.|
|schema_option||binary(8)||The bitmap of the schema generation option for the given schema-only article, which can be the bitwise logical OR the result of one or more of these values:|
0x00 = Disable scripting by the Snapshot Agent and uses the provided CreationScript.
0x01 = Generate the object creation (CREATE TABLE, CREATE PROCEDURE, and so on).
0x10 = Generate a corresponding clustered index.
0x20 = Convert user-defined data types to base data types.
0x40 = Generate corresponding nonclustered index or indexes.
0x80 = Include declared referential integrity on the primary keys.
0x100 = Replicate user triggers on a table article, if defined.
0x200 = Replicate foreign key constraints. If the referenced table is not part of a publication, all foreign key constraints on a published table are not replicated.
0x400 = Replicate check constraints.
0x800 = Replicate defaults.
0x1000 = Replicate column-level collation.
0x2000 = Replicate extended properties associated with the published article source object.
0x4000 = Replicate unique keys if defined on a table article.
0x8000 = Replicate a primary key and unique keys on a table article as constraints using ALTER TABLE statements.
For more information on possible values for schema_option, see sp_addmergearticle.
|destination_object||sysname||The name of the destination object in the subscription database. This value applies only to schema-only articles, such as stored procedures, views, and UDFs.|
|destination_owner||sysname||The owner of the object in the subscription database, if it is not dbo.|