Edit

IHcolumns (Transact-SQL)

  • Article

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)