I haven't really read this anywhere.

What is the proper way of deleting versioned data from an SDE geodatabase to make sure nothing is left behind in the A & D tables?

Do I need to unversion the data before I delete it? Do I need to remove the user versions? Or does it matter?


1 Answer 1


Unversioning removes the A and D tables associated with a single versioned feature class. Any edits not reconciled and posted to the base table will be lost, which appears to be your goal.

  • Okay, but what if I were to not unversion the data and delete it. Would it still do the same thing? Or could there possibly be tables left stranded out there?
    – ianbroad
    Mar 19, 2014 at 15:50
  • 1
    If you DROP the A & D tables without unversioning, you corrupt your geodatabase. If you use ArcGIS to delete the versioned feature classes it will clean up the instance correctly.
    – Vince
    Mar 19, 2014 at 16:30

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.