IHcolumns (Transact-SQL)
The IHcolumns system table contains one row for each published column. This table is used to define how column data types from the non-SQL Server Publisher will be represented when published, which essentially maps data types between a non-SQL Server database management systems (DBMS) and SQL Server. This table is stored in the distribution database.
Definition
| Column name | Data type | Description |
|---|---|---|
column_id |
int |
Identifies a published column. |
publishercolumn_id |
int |
Associates a published column with column metadata stored in the IHpublishercolumns system table. |
name |
sysname |
Specifies the column name. |
article_id |
int |
Identifies the article to which the column belongs. |
column_ordinal |
int |
Identifies the column by order. |
mapped_type |
tinyint |
The column data type of the destination column at Subscriber. |
mapped_length |
bigint |
The length of the column at Subscriber. |
mapped_prec |
int |
The precision of the column at Subscriber. |
mapped_scale |
int |
The scale of the column at Subscriber. |
mapped_nullable |
bit |
Indicates whether the column at the Subscriber accepts NULL values, where 1 means that NULL values are accepted. |
See Also
Reference
Replication Views (Transact-SQL)
sp_articlecolumn (Transact-SQL)
sysarticlecolumns (Transact-SQL)
Concepts
Replication Tables (Transact-SQL)
sysarticlecolumns (System View) (Transact-SQL)
Other Resources
Heterogeneous Database Replication