sysarticles (Transact-SQL)
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 Specify 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 Specify 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 = Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. 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 Specify 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. |
Zobacz także
Odwołanie
Replication Views (Transact-SQL)
sp_changearticle (Transact-SQL)