IHcolumns (Transact-SQL)
Applies to: 
SQL Server
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
Heterogeneous Database Replication
Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)
sp_articlecolumn (Transact-SQL)
sysarticlecolumns (System View) (Transact-SQL)
sysarticlecolumns (Transact-SQL)