IHpublisherindexes (Transact-SQL)

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

Reference

Replication Views (Transact-SQL)

Concepts

Replication Tables (Transact-SQL)

Other Resources

Heterogeneous Database Replication

Help and Information

Getting SQL Server 2005 Assistance