Skip to content

Latest commit

 

History

History
34 lines (29 loc) · 1.42 KB

msmerge-current-partition-mappings.md

File metadata and controls

34 lines (29 loc) · 1.42 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic f1_keywords helpviewer_keywords dev_langs
MSmerge_current_partition_mappings
MSmerge_current_partition_mappings
VanMSFT
vanto
03/04/2017
sql
replication
reference
MSmerge_current_partition_mappings
MSmerge_current_partition_mappings_TSQL
MSmerge_current_partition_mappings system table
TSQL

MSmerge_current_partition_mappings

[!INCLUDE SQL Server]

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)