ihpublishercolumns-transact-sql.md

title	IHpublishercolumns (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/03/2017
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	replication
ms.topic	language-reference
f1_keywords	IHpublishercolumns IHpublishercolumns_TSQL
dev_langs	TSQL
helpviewer_keywords	IHpublishercolumns system table
ms.assetid	a5347750-224c-40d9-ae12-57e7213b7db9
author	stevestein
ms.author	sstein

IHpublishercolumns (Transact-SQL)

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

The IHpublishercolumns system table represents metadata stored at the publisher. This table contains one row for each column replicated from non-SQL Server Publishers using the current Distributor. Data type information in IHpublishercolumns is specific to the non-SQL Server database management system (DBMS) from which the data is published. This table is stored in the distribution database.

Definition

Column name	Data type	Description
publishercolumn_id	int	Identifies a published column.
table_id	int	Identifies the source table from IHpublishertables to which the column belongs.
publisher_id	smallint	Identifies the non-SQL Server Publisher from which the column is being published.
name	sysname	The name of the published column.
column_ordinal	int	Identifies the column by order.
type	varchar(255)	The column data type of the source column at Publisher.
length	bigint	The length of the source column at Publisher.
prec	int	The precision of the source column at Publisher.
scale	int	The scale of the source column at Publisher.
isnullable	bit	Indicates whether the column accepts NULL values, where 1 means that NULL values are accepted.
iscaptured	bit	Indicates whether a trigger exists on the column, which may exist even if the column in not published in an article. A value of 1 means that the trigger exists on the column.

See Also

Heterogeneous Database Replication
Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)
sysarticlecolumns (System View) (Transact-SQL)
sysarticlecolumns (Transact-SQL)