ihcolumns-transact-sql.md

title	IHcolumns (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/06/2017
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	replication
ms.topic	language-reference
f1_keywords	IHcolumns_TSQL IHcolumns
dev_langs	TSQL
helpviewer_keywords	IHcolumns system table
ms.assetid	5bb027e5-5279-487b-9c33-5f402987253c
author	stevestein
ms.author	sstein

IHcolumns (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

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)