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.