Skip to content

Latest commit

 

History

History
39 lines (34 loc) · 1.87 KB

File metadata and controls

39 lines (34 loc) · 1.87 KB
title IHpublisherindexes (Transact-SQL) | Microsoft Docs
ms.custom
ms.date 03/06/2017
ms.prod sql
ms.prod_service database-engine
ms.reviewer
ms.technology replication
ms.topic language-reference
f1_keywords
IHpublisherindexes
IHpublisherindexes_TSQL
dev_langs
TSQL
helpviewer_keywords
IHpublisherindexes system table
ms.assetid 6008ef89-eeb9-46dc-93a2-f7623298cf0f
author stevestein
ms.author sstein

IHpublisherindexes (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

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)