topic Re: Deleting Table Records in Roads and Highways User Group (RHUG) Questions

Deleting Table Records

CameronCole2 — Mon, 20 Oct 2025 20:53:07 GMT

Hey all,

I am working with a registered event that we get the underlying table data from our DOT monthly.

The events are branch versioned and archived.

We don't care about versioning or any history of record. Every month we want to truncate the table and append into it. We have tried truncate table (which fails all together) and delete features. Delete features doesnt not remove the records from the history table so in SQL we are getting a large running table of the appends that we dont want.

What are the options for truly truncating the table and its history. I know we can delete using SQL but I dont wan to break triggers or any esri automation processes.

Re: Deleting Table Records

ElsitMandal1 — Tue, 21 Oct 2025 21:33:37 GMT

This tool may help? Prune branch history—ArcGIS Pro | Documentation

Re: Deleting Table Records

AmitHazra — Wed, 01 Apr 2026 18:44:47 GMT

Prune Branch History will not work for ArcGIS Location Referencing since we use a controller dataset. Only the Utility Network controller or topololgies can can leverage this tool. If you wish to remove the branch archive you'll need to un-version and then re-version your dataset. This will effectively replace the branch archive records.

-amit@esriTransportation