MSmerge_past_partition_mappings (Transact-SQL)

APPLIES TO: YesSQL Server NoAzure SQL Database NoAzure Synapse Analytics (SQL DW) NoParallel Data Warehouse

The MSmerge_past_partition_mappings table stores one row for each partition id a given changed row used to belong to, but no longer 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 the row belongs to. The value is -1 if the row change is relevant to all Subscribers.
generation bigint The value of the generation in which the partition change occurred.
reason tinyint Internal-use only.

See Also

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