Export (0) Print
Expand All
Expand Minimize

sysarticles (Transact-SQL)

Updated: 14 April 2006

Contains a row for each article defined in the local database. This table is stored in the published database.

Column name Data type Description

artid

int

The identity column that provides a unique ID number for the article.

creation_script

nvarchar(255)

The schema script for the article.

del_cmd

nvarchar(255)

The replication command type used when replicating deletes with table articles. For more information, see Specifying How Changes Are Propagated for Transactional Articles.

description

nvarchar(255)

The descriptive entry for the article.

dest_table

sysname

The name of the destination table.

filter

int

The stored procedure ID, used for horizontal partitioning.

filter_clause

ntext

The WHERE clause of the article, used for horizontal filtering.

ins_cmd

nvarchar(255)

The replication command type used when replicating inserts with table articles. For more information, see Specifying How Changes Are Propagated for Transactional Articles.

name

sysname

The name associated with the article, unique within the publication.

objid

int

The published table object ID.

pubid

int

The ID of the publication to which the article belongs.

pre_creation_cmd

tinyint

The pre-creation command for DROP TABLE, DELETE TABLE, or TRUNCATE:

0 = None.

1 = DROP.

2 = DELETE.

3 = TRUNCATE.

status

tinyint

The bitmask of the article options and status, which can be the bitwise logical OR result of one or more of these values:

1 = Article is active.

8 = Include the column name in INSERT statements.

16 = Use parameterized statements.

24 = Both include the column name in INSERT statements and use parameterized statements.

64 = The horizontal partition for the article is defined by a transformable subscription.

The transformable subscriptions feature for transactional replication has been deprecated. Support for this feature in the user interface has been dropped. Using the feature requires installing Microsoft SQL Server 2000 Data Transformation Services (DTS). For more information, see SQL Server 2005 Integration Services Backward Compatibility. For more information about transformable subscriptions, see Transforming Published Data.
ms187723.note(en-US,SQL.90).gifNote:

For example, an active article using parameterized statements would have a value of 17 in this column. A value of 0 means that the article is inactive and no additional properties are defined.

sync_objid

int

The ID of the table or view that represents the article definition.

type

tinyint

The type of article:

1 = Log-based article.

3 = Log-based article with manual filter.

5 = Log-based article with manual view.

7 = Log-based article with manual filter and manual view.

8 = Stored procedure execution.

24 = Serializable stored procedure execution.

32 = Stored procedure (schema only).

64 = View (schema only).

128 = Function (schema only).

upd_cmd

nvarchar(255)

The replication command type used when replicating updates with table articles. For more information, see Specifying How Changes Are Propagated for Transactional Articles.

schema_option

binary(8)

A bitmask of the schema generation options for the article, which control what parts of the article schema are scripted out for delivery to the Subscriber. For more information about schema options, see sp_addarticle (Transact-SQL).

dest_owner

sysname

The owner of the table at the destination database.

ins_scripting_proc

int

The registered custom stored procedure or script that is executed when an INSERT statement is replicated.

del_scripting_proc

int

The registered custom stored procedure or script that is executed when a DELETE statement is replicated.

upd_scripting_proc

int

The registered custom stored procedure or script that is executed when an UPDATE statement is replicated.

custom_script

nvarchar(2048)

The registered custom stored procedure or script that is executed at the end of the DDL trigger.

fire_triggers_on_snapshot

bit

Indicates whether or not replicated triggers are executed when the snapshot is applied, which can be one of these values:

0 = Triggers are not executed.

1 = Triggers are executed.

Release History

14 April 2006

Changed content:
  • Clarified the description for the schema_option column.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft