Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

IHextendedArticleView (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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.

Community Additions

ADD
Show:
© 2015 Microsoft