Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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