IHarticles (Transact-SQL)
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)