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.
Applies to: 
SQL Server
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
Heterogeneous Database Replication
Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)
sysarticlecolumns (System View) (Transact-SQL)
sysarticlecolumns (Transact-SQL)