The IHextendedArticleView view exposes information on articles in a non-SQL Server publication. This view is stored in the distribution database.
The unique identifier for the Publisher.
The unique identifier for the publication.
The name of the article
The name of the published object at the Subscriber.
The owner of the published object at the Publisher.
The name of the published object at the Publisher.
The description of the article.
The schema creation script for the article.
The command that is executed for a DELETE.
The identifier for the stored procedure used to define the horizontal partition.
The WHERE clause used to horizontally filter the article.
The command that is executed for an INSERT.
The Pre-creation command for DROP TABLE, DELETE TABLE, or TRUNCATE:
0 = None.
1 = DROP.
2 = DELETE.
3 = TRUNCATE.
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 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.
The command that is executed for a UPDATE.
Indicates what is to be scripted out. See sp_addarticle (Transact-SQL) for a list of supported schema options.
The owner of the published object at the destination database.