List of Dataverse with tables that can handle physical deleted records

(0) Share

Report

Posted on by SV-12091130-0

Hi all,

last week I noticed that the UserInfo-table handles deleted records differently.

It worked with physical deleted records, rather than logical deleted records as is the "normal" way.

Does someone have a list of tables that work the same way as the UserInfo-table, namely work with physical deleted records and not logical deleted records?

It changes my approach on how to handle the kind of records when loading them into our DataWareHouse.

Thanks in advance,

Sven

Categories:

Dynamics 365 general

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Sahan Hasitha 681 on at

Like (4)

Report

List of Dataverse with tables that can handle physical deleted records

• Detect Delete Behavior per Table
   Check TableProperties → TableType.
   System/Internal tables → often physical delete.
   Normal business tables → soft delete.
• Track Deletes Consistently
   For soft delete tables: watch ValidTo, DataAreaId, DeleteAction, or RecId presence.
   For hard delete tables: implement Change Tracking (CT) or DMF export with Change Feed so you catch the delete before it disappears.
• Recommended Approach
   Use BYOD with Change Tracking enabled → it captures hard deletes as a “tombstone row” in your SQL DB.
   Or, if using Entity Store → note that it does not track deletes (only current snapshot).
   For critical tables like UserInfo, always use BYOD + CT for DW loads.

2 people found this reply helpful.

Was this reply helpful? Yes No