IHextendedArticleView (Transact-SQL)
The IHextendedArticleView view exposes information on articles in a non-SQL Server publication. This view is stored in the distribution database.
| Column name | Data type | Description |
|---|---|---|
publisher_id |
smallint |
The unique identifier for the Publisher. |
publication_id |
int |
The unique identifier for the publication. |
article |
sysname |
The name of the article |
destination_object |
sysname |
The name of the published object at the Subscriber. |
source_owner |
sysname |
The owner of the published object at the Publisher. |
source_object |
sysname |
The name of the published object at the Publisher. |
description |
nvarchar(255) |
The description of the article. |
creation_script |
nvarchar(255) |
The schema creation script for the article. |
del_cmd |
nvarchar(255) |
The command that is executed for a DELETE. |
filter |
int |
The identifier for the stored procedure used to define the horizontal partition. |
filter_clause |
ntext |
The WHERE clause used to horizontally filter the article. |
ins_cmd |
nvarchar(255) |
The command that is executed for an INSERT. |
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. 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. |
type |
tinyint |
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 that is executed for a UPDATE. |
schema_option |
binary |
Indicates what is to be scripted out. See sp_addarticle (Transact-SQL) for a list of supported schema options. |
dest_owner |
sysname |
The owner of the published object at the destination database. |
See Also
Reference
Replication Views (Transact-SQL)
Concepts
Replication Tables (Transact-SQL)
Other Resources
Heterogeneous Database Replication