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