msmerge-past-partition-mappings-transact-sql.md

title	MSmerge_past_partition_mappings (Transact-SQL)
description	MSmerge_past_partition_mappings (Transact-SQL)
author	VanMSFT
ms.author	vanto
ms.date	03/03/2017
ms.service	sql
ms.subservice	replication
ms.topic	reference
f1_keywords	MSmerge_past_partition_mappings MSmerge_past_partition_mappings_TSQL
helpviewer_keywords	MSmerge_past_partition_mappings system table
dev_langs	TSQL

MSmerge_past_partition_mappings (Transact-SQL)

[!INCLUDE SQL Server]

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)