MSmerge_tombstone (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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

Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)