Share via


IHcolumns (Transact-SQL)

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

Reference

Replication Views (Transact-SQL)
sp_articlecolumn (Transact-SQL)
sysarticlecolumns (Transact-SQL)

Concepts

Replication Tables (Transact-SQL)
sysarticlecolumns (System View) (Transact-SQL)

Other Resources

Heterogeneous Database Replication

Help and Information

Getting SQL Server 2005 Assistance