topic Re: Deleting records in a Feature Class in sde in ArcGIS Pro Questions

Deleting records in a Feature Class in sde

BillMorgan1 — Mon, 03 Feb 2020 17:56:28 GMT

I need to delete about 30k records in a parcel feature class of about 170k. Then append new ones from a USB to replace the ones I deleted which will so include an update to those. Simply highlight and delete in attribute table using the highlighted "x" seems sketchy with that many? Is there another better way?

Re: Deleting records in a Feature Class in sde

RobertBorchert — Mon, 03 Feb 2020 20:17:38 GMT

It as easy as that. Delete the records you want to get rid of and append the new ones.

If your uneasy about doing so I would suggest exporting the feature to a file geodatabase. Deleting the records you don't want. Compressing the database the load the new records into the feature. compress it again.

then you can truncate the SDE feature class and load the updated records in

Re: Deleting records in a Feature Class in sde

BillMorgan1 — Tue, 04 Feb 2020 20:27:49 GMT

Thanks good info. The problem I had was I open the attr tables highlighted what needs to be replaced, deleted using the "delete selected" "X" in top left corner to put it simply. So then I appended through toolbox the gdb with the new stuff to the FC on SDE but after it was seemingly done, it only depended a few records not the entre gdb. No selection or query was turned on for this to happen. never had this happen before