IHpublishercolumns (Transact-SQL)
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)
Phản hồi
https://aka.ms/ContentUserFeedback.
Sắp ra mắt: Trong năm 2024, chúng tôi sẽ dần gỡ bỏ Sự cố với GitHub dưới dạng cơ chế phản hồi cho nội dung và thay thế bằng hệ thống phản hồi mới. Để biết thêm thông tin, hãy xem:Gửi và xem ý kiến phản hồi dành cho