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|
|tablenick||int||Nickname of the table.|
|type||tinyint||Type of delete:
1 = User 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.|
|reason||nvarchar(255)||Text field containing the reason that tombstone was created.|