sysextendedarticlesview (Transact-SQL)
The sysextendedarticlesview view provides information about published articles. This view is stored in the distribution 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 creation script for the article. |
del_cmd |
nvarchar(255) |
The command to execute upon DELETE; otherwise, construct from the log. |
description |
nvarchar(255) |
The descriptive entry for the article. |
dest_table |
nvarchar(128) |
The name of the destination table. |
filter |
int |
The object identifier of the stored procedure used for horizontal partitioning. |
filter_clause |
ntext |
The WHERE clause of the article, used for horizontal filtering. |
ins_cmd |
nvarchar(255) |
The command to execute upon INSERT. |
name |
nvarchar(128) |
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 |
int |
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. 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. |
upd_cmd |
nvarchar(255) |
The command to execute upon UPDATE; otherwise, construct from the log. |
schema_option |
binary |
Indicates what properties of the published object are scripted out in the snapshot. For a list of supported schema options, see sp_addarticle. |
dest_owner |
nvarchar(128) |
The owner of the table at the destination database. |
ins_scripting_proc |
int |
The object identifier of the custom stored procedure or script that is executed when an INSERT statement is replicated. |
del_scripting_proc |
int |
The object identifier of the custom stored procedure or script that is executed when a DELETE statement is replicated. |
upd_scripting_proc |
int |
The object identifier of the custom stored procedure or script that is executed when an UPDATE statement is replicated. |
custom_script |
int |
The object identifier of the custom script or procedure that is executed on the completion of a DDL trigger. |
fire_triggers_on_snapshot |
int |
Indicates whether 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. |
See Also
Reference
Replication Views (Transact-SQL)
sp_changearticle (Transact-SQL)