Skip to content

Latest commit

 

History

History
36 lines (31 loc) · 1.7 KB

ihpublisherindexes-transact-sql.md

File metadata and controls

36 lines (31 loc) · 1.7 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic f1_keywords helpviewer_keywords dev_langs
IHpublisherindexes (Transact-SQL)
IHpublisherindexes (Transact-SQL)
VanMSFT
vanto
03/06/2017
sql
replication
reference
IHpublisherindexes
IHpublisherindexes_TSQL
IHpublisherindexes system table
TSQL

IHpublisherindexes (Transact-SQL)

[!INCLUDE SQL Server]

The IHpublisherindexes system table contains one row for each index replicated from non-SQL Server Publishers using the current Distributor. This table is stored in the distribution database.

Column name Data type Description
publisherindex_id int Identifies a published index.
table_id int Identifies the table from IHpublishertables to which the index belongs.
publisher_id smallint Identifies the non-SQL Server Publisher from which the index is being published.
name sysname The name of the published index.
type nvarchar(255) A supported index type from the IHindextypes system table.

See Also

Heterogeneous Database Replication
Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)