Edit

IHextendedArticleView (Transact-SQL)

  • Article

Applies to: SQL Server

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

Heterogeneous Database Replication
Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)