IHpublishercolumns (Transact-SQL)

The IHpublishercolumns system table represents metadata stored at the publisher. This table contains one row for each column replicated from non-SQL Server Publishers using the current Distributor. Data type information in IHpublishercolumns is specific to the non-SQL Server database management system (DBMS) from which the data is published. This table is stored in the distribution database.

Definition

Column name Data type Description

publishercolumn_id

int

Identifies a published column.

table_id

int

Identifies the source table from IHpublishertables to which the column belongs.

publisher_id

smallint

Identifies the non-SQL Server Publisher from which the column is being published.

name

sysname

The name of the published column.

column_ordinal

int

Identifies the column by order.

type

varchar(255)

The column data type of the source column at Publisher.

length

bigint

The length of the source column at Publisher.

prec

int

The precision of the source column at Publisher.

scale

int

The scale of the source column at Publisher.

isnullable

bit

Indicates whether the column accepts NULL values, where 1 means that NULL values are accepted.

iscaptured

bit

Indicates whether a trigger exists on the column, which may exist even if the column in not published in an article. A value of 1 means that the trigger exists on the column.

See Also

Reference

Replication Views (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