IHpublishertables (Transact-SQL)

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

The IHpublishertables system table represents metadata stored at the publisher. This table contains one row for each source table published from a non-SQL Server Publisher using the current Distributor. This table is stored in the distribution database.

Column name Data type Description
table_id int Identifies a published table.
publisher_id smallint Identifies the non-SQL Server Publisher from which the table is being published.
name sysname The name of the published table.
owner sysname The table owner.

See Also

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