Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

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