Deleting Table Records

644
2
Jump to solution
10-20-2025 01:53 PM
CameronCole2
New Contributor

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. 

1 Solution

Accepted Solutions
AmitHazra
Esri Contributor

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

View solution in original post

0 Kudos
2 Replies
ElsitMandal1
Occasional Contributor
0 Kudos
AmitHazra
Esri Contributor

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

0 Kudos