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