sysschemaarticles (Transact-SQL)

Tracks schema-only articles for transactional and snapshot publications. This table is stored in the publication database.

Column name

Data type

Description

artid

int

The article ID.

creation_script

nvarchar(255)

The path and name of an article schema script used to create the target table.

description

nvarchar(255)

The descriptive entry for the article.

dest_object

sysname

The name of the object in the subscription database if the article is a schema-only article, such as stored procedure, view, or UDF.

name

sysname

The name of the schema-only article in a publication.

objid

int

The object identifier of the article base object. It can be the object identifier of a procedure, view, indexed, view, or UDF.

pubid

int

The ID for the publication.

pre_creation_cmd

tinyint

Specifies what the system should do if it detects an existing object of the same name at the Subscriber when applying the snapshot for this article:

0 = Nothing.

1 = Delete destination table.

2 = Drop destination table.

3 = Truncate destination table.

status

int

The bitmap used to indicate the status of the article.

type

tinyint

The value indicating the type of schema-only article:

0x20 = Stored procedure schema-only article.

0x40 = View schema-only article or indexed view schema-only article.

schema_option

binary(8)

The bitmask of the schema generation option for the given article. It specifies the automatic creation of the stored procedure in the destination database for all CALL/MCALL/XCALL syntaxes, and can be the bitwise logical OR result of one or more of these values: