Skip to content

Latest commit

 

History

History
34 lines (29 loc) · 1.42 KB

File metadata and controls

34 lines (29 loc) · 1.42 KB
title MSmerge_current_partition_mappings
description MSmerge_current_partition_mappings
author VanMSFT
ms.author vanto
ms.date 03/04/2017
ms.service sql
ms.subservice replication
ms.topic reference
f1_keywords
MSmerge_current_partition_mappings
MSmerge_current_partition_mappings_TSQL
helpviewer_keywords
MSmerge_current_partition_mappings system table
dev_langs
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)