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.|