IHpublisherindexes (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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)