Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

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 UDF.

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.