Transact-SQL Reference
MSmerge_tombstone
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 | Row identifier. |
| 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. |