| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MSmerge_past_partition_mappings (Transact-SQL) |
MSmerge_past_partition_mappings (Transact-SQL) |
VanMSFT |
vanto |
03/03/2017 |
sql |
replication |
reference |
|
|
|
[!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. |
Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)