| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MSmerge_tombstone (Transact-SQL) |
MSmerge_tombstone (Transact-SQL) |
VanMSFT |
vanto |
03/04/2017 |
sql |
replication |
reference |
|
|
|
[!INCLUDE SQL Server]
The MSmerge_tombstone table contains information on deleted rows and allows deletes to be propagated to other Subscribers. This table is stored in the publication and subscription databases.
| Column name | Data type | Description |
|---|---|---|
| rowguid | uniqueidentifier | The row identifier. |
| tablenick | int | The nickname of the table. |
| type | tinyint | The type of delete: 1 = User delete. 5 = Row no longer belongs to the filtered partition. 6 = System delete. |
| lineage | varbinary(249) | Indicates the version of the record that was deleted, and which updates were known when it was deleted. Allows rules for consistent resolution of a conflict when one Subscriber updates a row while it is being deleted at another Subscriber. |
| generation | int | Is assigned when a row is deleted. If a Subscriber requests generation N, only tombstones with generation >= N are sent. |
| logical_record_parent_rowguid | uniqueidentifier | Identifies the logical record to which a deleted row belongs. |
| logical_record_lineage | Varbinary(501) | The subscriber nickname, version number pairs that are used to maintain a history of deletes for the logical record to which this row belongs. |
Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)