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