Share via


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.