Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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)