IHarticles (Transact-SQL)
Applies to: SQL Server
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.
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. |
Heterogeneous Database Replication
Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)
sp_addarticle (Transact-SQL)
sp_changearticle (Transact-SQL)