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.