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.

Column nameData typeDescription
column_idintIdentifies a published column.
publishercolumn_idintAssociates a published column with column metadata stored in the IHpublishercolumns system table.
namesysnameSpecifies the column name.
article_idintIdentifies the article to which the column belongs.
column_ordinalintIdentifies the column by order.
mapped_typetinyintThe column data type of the destination column at Subscriber.
mapped_lengthbigintThe length of the column at Subscriber.
mapped_precintThe precision of the column at Subscriber.
mapped_scaleintThe scale of the column at Subscriber.
mapped_nullablebitIndicates whether the column at the Subscriber accepts NULL values, where 1 means that NULL values are accepted.

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

Community Additions