IHcolumns (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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 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)