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.
|
See Also