MSmerge_current_partition_mappings

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

The MSmerge_current_partition_mappings table stores one row for each partition id a given changed row belongs to. This table is stored in the publication database.

Column name Data type Description
publication_number smallint The publication number, which is stored in sysmergepublications.
tablenick int The nickname of the published table.
rowguid uniqueidentifier The row identifier for the given row.
partition_id int The ID of the partition to which the row belongs. The value is –1 if the row change is relevant to all Subscribers.

See Also

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