sysmergeschemaarticles (Transact-SQL)
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. |