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.
The IHarticles system table contains one row for each article being replicated from a non-SQL Server Publisher using the current Distributor. This table is stored in the distribution database.
Definition
Column name |
Data type |
Description |
|---|---|---|
article_id |
int |
The identity column that provides a unique ID number for the article. |
name |
sysname |
The name associated with the article, unique within the publication. |
publication_id |
smallint |
The ID of the publication to which the article belongs. |
table_id |
int |
The ID of the table being published from IHpublishertables. |
publisher_id |
smallint |
The ID of the Non-SQL Server Publisher. |
creation_script |
nvarchar(255) |
The schema script for the article. |
del_cmd |
nvarchar(255) |
The replication command type used when replicating deletes with table articles. For more information, see Specify How Changes Are Propagated for Transactional Articles. |
filter |
int |
This column is not used and is included only to make the sysarticles view of the IHarticles table compatible with the sysarticles view used for SQL Server articles (sysarticles). |
filter_clause |
ntext |
The WHERE clause of the article, used for horizontal filtering and written in an standard Transact-SQL that can be interpreted by the non-SQL Publisher. |
ins_cmd |
nvarchar(255) |
The replication command type used when replicating inserts with table articles. For more information, see Specify How Changes Are Propagated for Transactional Articles. |
pre_creation_cmd |
tinyint |
The command to execute before the initial snapshot is applied when an object with the same name already exists at the Subscriber. 0 = None - a command is not executed. 1 = DROP - drop the destination table. 2 = DELETE - delete data from the destination table. 3 = TRUNCATE - truncate the destination table. |
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: 0 = No additional properties. 1 = Active. 8 = Include the column name in INSERT statements. 16 = 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 |
The type of article: 1 = Log-based article. |
upd_cmd |
nvarchar(255) |
The replication command type used when replicating updates with table articles. For more information, see Specify How Changes Are Propagated for Transactional Articles. |
schema_option |
binary(8) |
The bitmap of the schema generation option for the given article, which can be the bitwise logical OR result of one or more of these values: 0x00 = Disable scripting by the Snapshot Agent and uses the provided CreationScript. 0x01 = Generate the object creation (CREATE TABLE, CREATE PROCEDURE, and so on). 0x10 = Generate a corresponding clustered index. 0x40 = Generate corresponding nonclustered indexes. 0x80 = Include declared referential integrity on the primary keys. 0x1000 = Replicates column-level collation. Note This option is set by default for Oracle Publishers to enable case-sensitive comparisons. 0x4000 = Replicate unique keys if defined on a table article. 0x8000 = Replicate a primary key and unique keys on a table article as constraints using ALTER TABLE statements. |
dest_owner |
sysname |
The owner of the table at the destination database. |
dest_table |
sysname |
The name of the destination table. |
tablespace_name |
nvarchar(255) |
Identifies the tablespace used by the logging table for the article. |
objid |
int |
This column is not used and is included only to make the sysarticles view of the IHarticles table compatible with the sysarticles view used for SQL Server articles (sysarticles). |
sync_objid |
int |
This column is not used and is included only to make the sysarticles view of the IHarticles table compatible with the sysarticles view used for SQL Server articles (sysarticles). |
description |
nvarchar(255) |
The descriptive entry for the article. |
publisher_status |
int |
Is used to indicate if the view that defines the published article has been defined by calling sp_articleview. 0 = sp_articleview has been called. 1 = sp_articleview has not been called. |
article_view_owner |
nvarchar(255) |
The owner of the synchronization object on the Publisher used by the Log Reader Agent. |
article_view |
nvarchar(255) |
The synchronization object on the Publisher used by the Log Reader Agent. |
ins_scripting_proc |
int |
This column is not used and is included only to make the sysarticles view of the IHarticles table compatible with the sysarticles view used for SQL Server articles (sysarticles). |
del_scripting_proc |
int |
This column is not used and is included only to make the sysarticles view of the IHarticles table compatible with the sysarticles view used for SQL Server articles (sysarticles). |
upd_scripting_proc |
int |
This column is not used and is included only to make the sysarticles view of the IHarticles table compatible with the sysarticles view used for SQL Server articles (sysarticles). |
custom_script |
int |
This column is not used and is included only to make the sysarticles view of the IHarticles table compatible with the sysarticles view used for SQL Server articles (sysarticles). |
fire_triggers_on_snapshot |
bit |
This column is not used and is included only to make the sysarticles view of the IHarticles table compatible with the sysarticles view used for SQL Server articles (sysarticles). |
instance_id |
int |
Identifies the current instance of the article log for the published table. |
use_default_datatypes |
bit |
Indicates whether the article uses default data type mappings; a value of 1 indicates that default data type mappings are used. |
See Also
Reference
Replication Views (Transact-SQL)
sp_changearticle (Transact-SQL)