Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
IHcolumns (Transact-SQL)
Collapse the table of content
Expand the table of content

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.

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.

Community Additions

ADD
Show:
© 2015 Microsoft